i am a fool - Mailing list pgsql-admin

From Hassanuri Bin Shah
Subject i am a fool
Date
Msg-id 39D74274.BA0ACE98@pc.jaring.my
Whole thread Raw
List pgsql-admin
hello
i don't know whether to ask here or the psql-sql but here goes...
how do i make a crosstab query from say:

job_no | year_month | input |
------------------
716        20004                100
717        20005                120
716        20006                130


to

job_no |  20004 | 20005 | 20006
-------------------
716        100                        130
717                          120


thank you.. in advance.

[x]



Attachment

pgsql-admin by date:

Previous
From: Ralf Tschiersch
Date:
Subject: pg_log deleted - what to do?
Next
From: Ralf Tschiersch
Date:
Subject: Structure damaged? Need help