Postgres Pro
Downloads
Home   >   mailing lists

Re: Order by YYYY MM DD in reverse chrono order trouble - Mailing list pgsql-sql

From Tom Lane
Subject Re: Order by YYYY MM DD in reverse chrono order trouble
Date
Msg-id 25337.1082638880@sss.pgh.pa.us
Whole thread Raw
In response to Re: Order by YYYY MM DD in reverse chrono order trouble  (<ogjunk-pgjedan@yahoo.com>)
Responses Re: Order by YYYY MM DD in reverse chrono order trouble  (<ogjunk-pgjedan@yahoo.com>)
List pgsql-sql
Tree view 
<ogjunk-pgjedan@yahoo.com> writes:
> I'd love to be able to do that, but I cannot just ORDER BY uu.add_date,
> because I do not have uu.add_date in the SELECT part of the statement. 

Sure you can.  Back around SQL89 there was a restriction that ORDER BY
values had to appear in the SELECT list as well, but no modern database
has such a restriction anymore ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Trigger calling a function HELP ME! (2)
Next
From: Rod Taylor
Date:
Subject: Re: Server Side C programming Environment Set up