Re: data type of projected item in a union not correct

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