you put a conditional clause in the order by statement, either by referencing a column that is populated conditionally, like this
select A, when B < C Then B else C end as condColumn, B, C, D from ... where ... order by 1,2, 5 or select A, when B < C Then B else C end as condColumn, B, C, D from ... where ... order by A,condColumn, D or you can just put the conditional statement in the order by clause (which surprised me, but I tested it) select A, B, C, D from ... where ... order by A,when B < C then B else C end, D On Wed, Sep 12, 2012 at 2:44 PM, Rodrigo Rosenfeld Rosas <rr.ro...@gmail.com > wrote: > This is my first message in this list :) > > I need to be able to sort a query by column A, then B or C (which one > is smaller, both are of the same type and table but on different left > joins) and then by D. > > How can I do that? > > Thanks in advance, > Rodrigo. > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
