From: | Dana(dot)Reed(at)clinicaldatacare(dot)com |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | SQL (table transposition) |
Date: | 2000-08-03 17:24:13 |
Message-ID: | TFSUYCTU@clinicaldatacare.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Is there any way to get table T3 (below) from T1 and T2 using SQL (select, view, etc)?
T3 is basically all INDEX values from T1 matched to IND from T2 with the corresponding KEY/VALUE pairs transposed from rows to columns.
-------
|INDEX| (T1)
-------
| 1 |
| 2 |
| 3 |
-------
-----------------
|IND|KEY| VALUE | (T2)
-----------------
| 1 | 1 | val_a |
| 1 | 2 | val_b |
| 1 | 3 | val_c |
| 2 | 1 | val_d |
| 2 | 2 | val_e |
| 3 | 1 | val_f |
| 3 | 3 | val_g |
-----------------
----------------------------------
|T1_INDEX|KEY1VAL|KEY2VAL|KEY3VAL| (T3)
----------------------------------
| 1 | val_a | val_b | val_c |
| 2 | val_d | val_e | |
| 3 | val_f | | val_g |
----------------------------------
Thanks for any suggestions
med vänlig hälsning
/Dana
From | Date | Subject | |
---|---|---|---|
Next Message | Alexaki Sofia | 2000-08-03 17:51:44 | A question about indexes... |
Previous Message | Mark Volpe | 2000-08-03 15:46:27 | Re: SQL (table transposition) |