From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000679 ] UNION select returns wrong column type with ADO (VB6) |
Date: | 2006-07-03 10:55:56 |
Message-ID: | 20060703105556.9394286C5DD@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-07-03 18:24:02 | [ psqlodbc-Bugs-1000680 ] Problem with datatype when use selct id, sum(col) from table group by id |
Previous Message | Philippe Lang | 2006-07-03 09:44:05 | Dynamic graphics generation inside plperlu query, odbc and MS Access display |