Re: AW: UNIONS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zeugswetter Andreas SB <ZeugswetterA(at)Wien(dot)Spardat(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: AW: UNIONS
Date: 2000-08-08 13:21:02
Message-ID: 19396.965740862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zeugswetter Andreas SB <ZeugswetterA(at)Wien(dot)Spardat(dot)at> writes:
>> The UNION type-resolution code could use some work; right now I think
>> the algorithm is to use the types of the first SELECT and force
>> everything else into that.

> Imho this is expected behavior (maybe even standard).

Wrong. Read the spec (see 9.3 in SQL99).

regards, tom lane

In response to

  • AW: UNIONS at 2000-08-08 07:39:55 from Zeugswetter Andreas SB

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-08-08 13:53:18 Re: [HACKERS] Re: Trouble with float4 afterupgrading from 6.5.3 to 7.0.2
Previous Message Don Baccus 2000-08-08 12:50:00 Re: Re: [GENERAL] Trouble with float4 afterupgrading from 6.5.3 to 7.0.2