Stefan Schwarzer wrote:
Hi there,
if I order a given year in DESCending ORDER, so that the highest
values (of a given variable) for the countries are displayed at the
top of the list, then actually the NULL values appear as first. Only
below, I find the values ordered correctly.
Is there any way to
a) make the countries with NULL values appear at the bottom of the list
... ORDER BY y_2000 IS NULL [DESC], y_2000;
b) neglect the NULL values by still allowing the countries to be
displayed
Not quite sure what you mean by this.
--
Tommy Gildseth
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
