On 1/26/2007 3:41 PM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
Checked it against HEAD and 8.2:
postgres=# select 1, 1, 1 union select * from (select 2, null, 2) two;
ERROR: failed to find conversion function from "unknown" to integer
It's always done that. The SQL spec would t
Jan Wieck <[EMAIL PROTECTED]> writes:
> Checked it against HEAD and 8.2:
> postgres=# select 1, 1, 1 union select * from (select 2, null, 2) two;
> ERROR: failed to find conversion function from "unknown" to integer
It's always done that. The SQL spec would tell you that you have to
cast the nu
Checked it against HEAD and 8.2:
postgres=# select 1, 1, 1 union select * from (select 2, null, 2) two;
ERROR: failed to find conversion function from "unknown" to integer
Jan
--
#==#
# It's easier to get forgiveness for bein