Re: help with query: advanced ORDER BY...

> 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?

cheers,
thomas