"Julien Vallet" <julien(dot)vallet(at)density-tech(dot)com> writes:
> The result is "ERROR: UNION types text and bigint cannot be matched"
This is the identical issue reported here:
See also this thread:
The short answer is that what you wrote is illegal per the SQL spec
(which doesn't allow NULL to be used in ways where a type can't be
ascribed immediately). While we'd like to accept it, we have
not figured out a rule that doesn't break the spec in other ways.
For now I'd recommend casting the NULLs explicitly.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Neil Conway||Date: 2005-05-23 14:02:32|
|Subject: Re: BUG #1671: Long interval string representation rejected|
|Previous:||From: Julien Vallet||Date: 2005-05-23 11:49:12|
|Subject: BUG #1677: Bug in select with Union|