Re: How to convert rows into HTML columns? - Mailing list pgsql-general

From Stefan Schwarzer
Subject Re: How to convert rows into HTML columns?
Date
Msg-id AFB440A5-96C3-48D7-9E72-83B3358927EE@grid.unep.ch
Whole thread Raw
In response to Re: How to convert rows into HTML columns?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: How to convert rows into HTML columns?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
>>
>> 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.

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to convert rows into HTML columns?
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to convert rows into HTML columns?