Re: CROSS-TAB query help? I have read it cant be done in on - Mailing list pgsql-sql

From Richard Huxton
Subject Re: CROSS-TAB query help? I have read it cant be done in on
Date
Msg-id 4121D475.3070804@archonet.com
Whole thread Raw
In response to Re: CROSS-TAB query help? I have read it cant be done in on  (Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>)
List pgsql-sql
Theo Galanakis wrote:
> Thanks Rickard 
> Max may not work as not all the data is numerical. However I will give the
> contrib/cross-tab a go!

It will work as long as you only have one non-null value per grouped 
field (which you did in your example).

>>|     symbol     | linktype
>>-------------------+------+------+-------------------+-----------+----
>>-------------------+------+------+-------------------+-----------+----
>>-------------------+------+------+-------------------+-----------+--
>>            100473 | 93   |      |                   |           |
>>            100473 |      | 77   |                   |           |
>>            100473 |      |      | text1            |           |


--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: multi column foreign key for implicitly unique columns
Next
From: Markus Bertheau
Date:
Subject: Re: multi column foreign key for implicitly unique columns