> 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