Re: Order by YYYY MM DD in reverse chrono order trouble

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ogjunk-pgjedan(at)yahoo(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Order by YYYY MM DD in reverse chrono order trouble
Date: 2004-04-22 13:01:20
Message-ID: 25337.1082638880@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<ogjunk-pgjedan(at)yahoo(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ogjunk-pgjedan 2004-04-22 13:37:09 Re: Order by YYYY MM DD in reverse chrono order trouble
Previous Message Richard Huxton 2004-04-22 11:19:12 Re: Trigger calling a function HELP ME! (2)