Hello,

"NULLS LAST" seems to be part of the SQL 99 standard but is not implemented in Monetdb.

Do you think it could be implemented in Monetdb? Can I fill a bug? Can I help you in some way?

The syntax is as follows:
ORDER BY [COLUMN NAME] [ASC | DESC] [NULLS FIRST | NULLS LAST]

In different DBs, the sorting of nulls relative to other values is handled differently.
PostgreSQL - Nulls are considered HIGHER than non-nulls.
DB2 - Higher
Oracle - Higher

MySQL - Lower
Monetdb - Lower

Thanks

--
Matthieu Guamis
Logo Axège Axège
22 bis, rue des Chazots
63170 Aubière
Tél: +33 (0)4 63 05 95 40
Fax: +33 (0)4.73.70.65.29
Email: matthieu.guamis@axege.com