Re: Seemingly inconsistent ORDER BY behavior

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Seemingly inconsistent ORDER BY behavior
Дата
Msg-id CAOR=d=1US2Vx_FdhYm=sN2g=mXvrF9wb1VwsiX1oW2ru4HZM+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seemingly inconsistent ORDER BY behavior  (Richard Hipp <drh@sqlite.org>)
Список pgsql-general
On Wed, Aug 14, 2013 at 12:31 PM, Richard Hipp <drh@sqlite.org> wrote:
>
>
> On Wed, Aug 14, 2013 at 2:28 PM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
>>
>> On Wed, Aug 14, 2013 at 12:01 PM, Richard Hipp <drh@sqlite.org> wrote:
>>
>> substr(m,2) as m
>>
>> is bad form. Always use a new and unique alias, like m1.  How does this
>> work:
>>
>> SELECT '2', substr(m,2) AS m1
>>   FROM t1
>>  ORDER BY lower(m1);
>
>
> Tnx.  I think everybody agrees that "substr(m,2) as m" is bad form.  And all
> the database engines get the same consistent answer when you avoid the bad
> form and use "substr(m,2) as m1" instead.  The question is, what should the
> database engine do when the programmer disregards sounds advice and uses the
> bad form anyhow?

My guess is that either the SQL spec says it's system determined OR
that the way postgres does it is right. And I'm leaning towards the
second. Someone with the spec hand would have to look it up.


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

Предыдущее
От: Richard Hipp
Дата:
Сообщение: Re: Seemingly inconsistent ORDER BY behavior
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Seemingly inconsistent ORDER BY behavior