And the next question coming up is: How should my query look like so
that I can sort the (HTML) table by a specific year in ascending or
descending order? So, that it doesn't display it by the country names
alphabetical order, but by, say 1998?
If you have only one row, how would you sort this result? ;-)
With the "old" design I had up to 240 rows - for each country/
territory one row. Now, I have 240*num_years rows.
The user should be able to sort then the resulting table by country
name as well as by any year in ASC or DESC order.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
