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=1000679&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=1000679&group_id=1000125