Hi,
I have a table like this: location | numbrochures | marketing
-----------------------+--------------+-----------101 Asheville, NC | 4 | NEWS101 Asheville, NC |
1 | TV101 Asheville, NC | 3 | RADIO101 Asheville, NC | 2 | OTHER101 Asheville, NC
| 3 | null101 Asheville, NC | 1 | TV102 'Charlotte', 'NC' | 1 | SIGN104
'Colfax','NC' | 5 | SIGN109 '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/