Hi,
I have a table like this:
location | numbrochures | marketing
-----------------------+--------------+-----------
101 Asheville, NC | 4 | NEWS
101 Asheville, NC | 1 | TV
101 Asheville, NC | 3 | RADIO
101 Asheville, NC | 2 | OTHER
101 Asheville, NC | 3 | null
101 Asheville, NC | 1 | TV
102 'Charlotte', 'NC' | 1 | SIGN
104 'Colfax', 'NC' | 5 | SIGN
109 'Moyock', 'NC' | 1 | BROCHURE
(9 rows)
I want the headings to be like:
location | NEWS | TV | RADIO | OTHER | ........
How to get this done using sql for postgresql backend?
TIA,
Sri.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
