On Oct 5, 2007, at 1:20 , Stefan Schwarzer wrote:
Before I was used that the yearly values were all to be found in a
single SQL row; now for each year of each country I have a separate
row. How do I convert that into a single (HTML) row again?
Take a look at the crosstab functions in contrib/tablefunc.
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?
Same way you would otherwise -- ORDER BY -- after using crosstab.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
