Re: help with query: advanced ORDER BY... - Mailing list pgsql-novice

On Sat, Jan 14, 2006 at 09:32:03PM +0100, me@alternize.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