Search Postgresql Archives

Re: Seemingly inconsistent ORDER BY behavior

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Wed, Aug 14, 2013 at 2:28 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
On Wed, Aug 14, 2013 at 12:01 PM, Richard Hipp <drh@xxxxxxxxxx> 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?

--
D. Richard Hipp
drh@xxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux