Postgres Pro
Downloads
Home   >   mailing lists

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

From the6campbells
Subject data type of projected item in a union not correct
Date
Msg-id CAFEjsq6LYuK-gtJmg3fa+QLmOr7fsRvUErrbZSQC=jADuXnRfg@mail.gmail.com
Whole thread Raw
Responses Re: data type of projected item in a union not correct  (David Johnston <polobo@yahoo.com>)
Re: data type of projected item in a union not correct  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view
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



pgsql-jdbc by date:

Previous
From: David Johnston
Date:
Subject: Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?
Next
From: David Johnston
Date:
Subject: Re: data type of projected item in a union not correct