[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Order by, expressions & column aliases issue
From:       "John D. Burger" <john () mitre ! org>
Date:       2005-12-30 18:40:20
Message-ID: f1e7a55588421790aceb4d89f83d35da () mitre ! org
[Download RAW message or body]

Jeff Trout wrote:

> This isn't terribly clear in the documentation.
>
> But it seems, in 8.0.3 and 8.1.1 that you cannot use a column alias in 
> an order by if you are using an expression (ie order by 
> my_column_alias <> 0 asc). If you use a plain asc/desc order by then 
> it is fine (ie order by my_column_alias asc).

Yah - I ran into this a few months ago.  Here's Tom's comments:

   http://archives.postgresql.org/pgsql-general/2005-10/msg00208.php

- John Burger
   MITRE


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]