Re: Case in Order By Ignored without warning or error

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Case in Order By Ignored without warning or error
Дата
Msg-id CA+bJJbzNjV59dCoi2BE1JiG3k0rnChPLkqU+5Dr-+HZ58A7t7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Case in Order By Ignored without warning or error  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
David:

On Thu, Jun 9, 2016 at 5:15 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> I think its a fair characterization to call "sorting on a constant" as
> "doing nothing" or "not useful".  There is no noticeable difference between
> that and omitting the constant.

Yes, but in that context I wanted to point it was correctly parsing
and evaluating the expression and comparing the result ( the optimizer
may have zapped it, but this is transparent to the user ).


Francisco Olarte.

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Следующее
От: AP
Дата:
Сообщение: Re: BUG #14178: output of jsonb_object and json_object doesn't match textually