Re: data type of projected item in a union not correct - Mailing list pgsql-jdbc

On Mon, 24 Sep 2012, the6campbells wrote:

> The following projection is not described with the expected type+precision
> as one would expect from ISO-SQL
>
> Is this a known Postgres bug, quirk or ....

This is a serverside problem.  Try the same test in psql or similar.

jurka=# create table t as select 'a'::varchar(32) as c1,
'b'::varchar(32) as c2 union select 'c'::char(32),
'd'::varchar(32);
SELECT 2
jurka=# \d t
              Table "public.t"
 Column |         Type          | Modifiers
--------+-----------------------+-----------
 c1     | character varying     |
 c2     | character varying(32) |


As you can see the c1 column has had the length information dropped.

Kris Jurka