Postgres Pro
Downloads
Home   >   mailing lists

Re: default value returned from sql stmt - Mailing list pgsql-general

From Richard Huxton
Subject Re: default value returned from sql stmt
Date
Msg-id 4F7563F5.8090608@archonet.com
Whole thread Raw
In response to Re: default value returned from sql stmt  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: default value returned from sql stmt
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: leaf_yxj
Date:
Subject: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.
Next
From: Pavel Stehule
Date:
Subject: Re: default value returned from sql stmt