Thread: [ 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=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