Hello,

I am using PostgreSQL 7.4.2 and as I understand NULL values always sort last.

However, I have a table from which select using two numerical sort keys "FROM" and "TO". "TO" might be NULL and I would like to display those rows first (without sorting the column in descending order).

Is there any way this can be achieved without inserting bogus values into that column?

--


Regards/Gruß,

Tarlika Elisabeth Schmitz

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to