On Thu, Aug 25, 2005 at 09:53:26AM +0100, THIBAULT Jean-Jacques wrote:
>
> this query work :
> select null UNION 1;
Please show the *exact* query. The above produces a syntax error:
test=> select null UNION 1;
ERROR: syntax error at or near "1" at character 19
LINE 1: select null UNION 1;
Andreas Pflug <[EMAIL PROTECTED]> writes:
> You probably mean
> SELECT NULL
> UNION
> SELECT NULL
> UNION
> SELECT 1
This has come up a couple of times before. It'd probably be possible to
resolve the type across all the union'd selects at once, using the same
rules as we do for CASE. The thing
THIBAULT Jean-Jacques wrote:
The following bug has been logged online:
Bug reference: 1847
Logged by: THIBAULT Jean-Jacques
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux (Mandrake)
Description:Error in some kind of UNION query.
De
The following bug has been logged online:
Bug reference: 1847
Logged by: THIBAULT Jean-Jacques
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux (Mandrake)
Description:Error in some kind of UNION query.
Details:
this query work :
sel
