Re: default value returned from sql stmt

From: Richard Huxton <dev(at)archonet(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: David Salisbury <salisbury(at)globe(dot)gov>, pgsql-general(at)postgresql(dot)org
Subject: Re: default value returned from sql stmt
Date: 2012-03-30 07:42:45
Message-ID: 4F7563F5.8090608@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2012-03-30 07:46:52 Re: default value returned from sql stmt
Previous Message leaf_yxj 2012-03-30 03:19:25 Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.