On Sat, Jan 14, 2006 at 09:32:03PM +0100, me(at)alternize(dot)com wrote:
> >Something like this might work:
> >
> >SELECT * FROM table1
> >ORDER BY field1,
> > CASE WHEN field1 THEN field2 ELSE NULL END,
> > CASE WHEN field1 THEN field3 ELSE NULL END,
> > CASE WHEN field1 THEN NULL ELSE field3 END,
> > CASE WHEN field1 THEN NULL ELSE field2 END;
>
>
> it indeed does, thanks alot. will pgsql still use the indices when ordering
> through CASE?
I don't think so, unless you define a multicolumn index on those
specific expressions.
Why the different ordering? What are you doing?
--
Michael Fuhr