Search Postgresql Archives

Re: default value returned from sql stmt

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



2012/3/30 Richard Huxton <dev@xxxxxxxxxxxx>:
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [PHP Classes]     [Find Someone Nice]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

Add to Google Powered by Linux