I would like to sort on a varchar column but have the rows having a null value for the sort column appear first in the result set as opposed to last.
I tried using NULLS LAST in the ORDER BY but that didn't work:
Code: Select all
dbadmin=> select my_data from null_sort_test order by my_data nulls last;
ERROR: syntax error at or near "nulls" at character 53
LINE 1: ...lect my_data from null_sort_test order by my_data nulls last...
For instance:
Code: Select all
------------------------------
QUERY PLAN DESCRIPTION:
------------------------------
explain select my_data from null_sort_test order by my_data;
Access Path:
+-STORAGE ACCESS for null_sort_test [Cost: 649, Rows: 10K (NO STATISTICS)] (PATH ID: 2)
| Projection: test.null_sort_test_super
| Materialize: null_sort_test.my_data
| Execute on: Query Initiator
------------------------------
QUERY PLAN DESCRIPTION:
------------------------------
explain select my_data from null_sort_test order by my_data desc;
Access Path:
+-SORT [Cost: 1K, Rows: 10K (NO STATISTICS)] (PATH ID: 1)
| Order: null_sort_test.my_data DESC
| Execute on: Query Initiator
| +---> STORAGE ACCESS for null_sort_test [Cost: 649, Rows: 10K (NO STATISTICS)] (PATH ID: 2)
| | Projection: test.null_sort_test_super
| | Materialize: null_sort_test.my_data
| | Execute on: Query Initiator
Thanks in advance!