Re: SQL Challenge: Arbitrary Cross-tab

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL Challenge: Arbitrary Cross-tab
Date: 2004-08-18 18:52:56
Message-ID: 200408181152.56040.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2004-08-18 18:55:34 Re: multi column foreign key for implicitly unique columns
Previous Message Jan Wieck 2004-08-18 18:01:52 Re: multi column foreign key for implicitly unique columns