[ psqlodbc-Bugs-1000679 ] UNION select returns wrong column type with ADO (VB6)

Bugs item #1000679, was opened at 2006-07-03 12:55
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 79&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: István Nagy (nagyi)
Assigned to: Nobody (None)
Summary: UNION select returns wrong column type with ADO (VB6)

Initial Comment:
If you do a UNION query like this:

SELECT (name || 'dummy')::varchar AS NewName FROM union_bug UNION
SELECT name AS NewName FROM union_bug ORDER BY newname

you get the data type adLongVarChar in the first field.

Table definition:
CREATE TABLE union_bug
(
name varchar(15) NOT NULL,
CONSTRAINT union_bug_pkey PRIMARY KEY (name)
)

In pgAdmin III the data type shown is varchar, so the bug must be in the ODBC driver.

István

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 79&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match