data type of projected item in a union not correct

From: the6campbells <the6campbells(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: data type of projected item in a union not correct
Date: 2012-09-24 23:43:37
Message-ID: CAFEjsq6LYuK-gtJmg3fa+QLmOr7fsRvUErrbZSQC=jADuXnRfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Database 9.0.4
Driver PostgreSQL 9.1 JDBC4 (build 902)

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 ....

t1.c1 char(32)
t2.c1 varchar(32)

select t1.c1 returns precision of 32
select t2.c1 returned precision of 32

t1.c1
union
t2.c1

t2.c1
union
t1.c1

returns precision 2147483647

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Johnston 2012-09-25 00:29:12 Re: data type of projected item in a union not correct
Previous Message Dave Cramer 2012-09-24 18:45:55 Re: When will your JDBC 4.0 driver implement DatabaseMetadata.getFunctions?