Hi,

SELECT name FROM customer ORDER BY country

Above query fails with error:   ORDER BY: no such column 'country'

According the Reference manual I expected this to work. Following is the
excerpt from Appendix A: SQL Features

E121-02 ORDER BY columns need not be in select list     S

My version of MonetDB is v5.0.0._beta1_2.

Please let me know if this is expected behaviour or am I missing something.

Thanks,

- Venkatesh
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
MonetDB-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply via email to