Re: Case in Order By Ignored without warning or error - Mailing list pgsql-bugs

From Francisco Olarte
Subject Re: Case in Order By Ignored without warning or error
Date
Msg-id CA+bJJbzNjV59dCoi2BE1JiG3k0rnChPLkqU+5Dr-+HZ58A7t7w@mail.gmail.com
Whole thread Raw
In response to Re: Case in Order By Ignored without warning or error  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Next
From: AP
Date:
Subject: Re: BUG #14178: output of jsonb_object and json_object doesn't match textually