Horton

Re: default value returned from sql stmt

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: David Salisbury <salisbury@globe.gov>, pgsql-general@postgresql.org
Date: 2012-03-30T07:42:45Z
Lists: pgsql-general 
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.

-- 
   Richard Huxton
   Archonet Ltd