| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: CROSS-TAB query help? I have read it cant be done in on |
| Date: | 2004-08-17 09:48:37 |
| Message-ID: | 4121D475.3070804@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Bertheau | 2004-08-17 09:49:57 | Re: multi column foreign key for implicitly unique columns |
| Previous Message | Oliver Elphick | 2004-08-17 09:39:36 | Re: multi column foreign key for implicitly unique columns |