Re: default value returned from sql stmt

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: default value returned from sql stmt
Дата
Msg-id CAFj8pRC+S5Hx_QRP-TBS08NW-he4sd-TmvGBFBj0_n7z4E7EFA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: default value returned from sql stmt  (Richard Huxton <dev@archonet.com>)
Ответы Re: default value returned from sql stmt  (Richard Huxton <dev@archonet.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: default value returned from sql stmt
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.