even more exciting in this context would be to add user controllable NULL sorting behaviour. afaik this is in sql:2003.
ORDER BY .. [ NULLS (FIRST|LAST) ] ?
Wait a bit :), I'm waiting for separate 8.2 branch. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq