Horton

Re: default value returned from sql stmt

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Richard Huxton <dev@archonet.com>
Cc: David Salisbury <salisbury@globe.gov>, pgsql-general@postgresql.org
Date: 2012-03-30T07:46:52Z
Lists: pgsql-general 
2012/3/30 Richard Huxton <dev@archonet.com>:
> On 29/03/12 23:28, Pavel Stehule wrote:
>>
>> select anum from t1 where anum = 4
>> union all select 100 limit 1;
>
>
> I'm not sure the ordering here is guaranteed by the standard though, is it?
> You could end up with the 4 being discarded.

A order is random for only "UNION", "UNION ALL" should to respect
order.  But I didn't check it in standard.

Pavel

>
> --
>  Richard Huxton
>  Archonet Ltd