Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Challenge: Arbitrary Cross-tab - Mailing list pgsql-sql

From Josh Berkus
Subject Re: SQL Challenge: Arbitrary Cross-tab
Date
Msg-id 200408181152.56040.josh@agliodbs.com
Whole thread Raw
In response to Re: SQL Challenge: Arbitrary Cross-tab  (Joe Conway <mail@joeconway.com>)
List pgsql-sql
Tree view 
Joe,

>   case_id | tk1 | tk2 | tk3 | tk4 | tk5 | tk6 | tk7 | tk8
> ---------+-----+-----+-----+-----+-----+-----+-----+-----
>    132113 | 021 | 115 | 106 |     |     |     |     |
>    140000 | 106 | 021 | 115 | 108 | 006 | 042 | 142 | 064
>    213447 | 047 |     |     |     |     |     |     |

Darn I wish this didn't have to be portable ....

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: multi column foreign key for implicitly unique columns
Next
From: Josh Berkus
Date:
Subject: Re: multi column foreign key for implicitly unique columns