Skip site navigation (1) Skip section navigation (2)

SQL (table transposition)

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 (view raw or flat)
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

Responses

pgsql-sql by date

Next:From: Alexaki SofiaDate: 2000-08-03 17:51:44
Subject: A question about indexes...
Previous:From: Mark VolpeDate: 2000-08-03 15:46:27
Subject: Re: SQL (table transposition)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group