Hi,

I'm struggling for some time with the following problem:

I have a table like this:

name key value
-------------------------
andi age 23
andi hometown boston
tom age 45
greg hometown miami


I would like to get the following through a SQL Select Statement:


name age hometown
-------------------------
andy 23 boston
tom 45 NULL
greg NULL miami

I thought about a subselect, but could'nt find the clue.

Thanks for any input,
best regards,
alex.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Thu, Oct 14, 2004 at 09:46:33PM +0200, Alexander Pucher wrote:
Take a look at the crosstab functions in contrib/tablefunc.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings