Re: [SQL] turning a table by 90 degrees - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: [SQL] turning a table by 90 degrees
Date
Msg-id Pine.LNX.4.20.9912090107520.389-100000@localhost.localdomain
Whole thread Raw
In response to turning a table by 90 degrees  (news-list.pgsql.sql@innominate.de (Thilo Mezger))
List pgsql-sql
On 1999-12-08, Thilo Mezger mentioned:

> hi,
> 
> i've got a table like this (plus a primary key and some other fields):
> 
> key      | value   | custid
> ---------+---------+---------
> name     | peter   | 2
> age      | 123     | 2
> foo      | bar     | 2
> [...]    |         |
> name     | john    | 3
> [...]
> 
> you can think of a table which is turned by 90 degrees.  this can be
> quite useful when you don't know in advance what key/values pairs you
> have to store.
> 
> now it would be nice to find a query which returns this result for
> custid=2:
> 
> name  | age | foo
> ------+-----+------
> peter | 123 | bar

I don't see why a table
SELECT * FROM your_table WHERE custid = 2;
would be any different. Just switch the column and row addressing logic in
your application.

key      | value   | custid
---------+---------+---------
name     | peter   | 2
age      | 123     | 2
foo      | bar     | 2

There's really no way to do what you suggested.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




pgsql-sql by date:

Previous
From: "Graeme Merrall"
Date:
Subject: timestamp/now in views
Next
From: Tom Lane
Date:
Subject: Re: [SQL] timestamp/now in views