From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Alessandro Vincelli <av(at)alessandro(dot)vincelli(dot)name> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: question abut "order by" null fields |
Date: | 2005-07-01 13:59:52 |
Message-ID: | 20050701135952.GA14301@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jul 01, 2005 at 11:21:06AM +0200, Alessandro Vincelli wrote:
>
> SELECT column1, column2 FROM table1 LEFT JOIN table2 USING (id)
> ORDER BY column1, column2
>
> In the rows where column1 is not null postgres perform ORDER BY column1,
> column2
>
> Problem:
> In the rows where Column1 is null, postgres don't perform ORDER BY on
> the column2
Please post a complete example: the SQL statements to create,
populate, and query the tables, as well as the results you expect
to see and the results you actually get.
What version of PostgreSQL are you running, and on what platform?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Masse Jacques | 2005-07-01 14:21:06 | Re: admin library - solved |
Previous Message | Tom Lane | 2005-07-01 13:41:54 | Re: PostgreSQL sequence within function |