In Oracle you can use cursors as columns. not sure if that will work
in postgresql. never tried it. =) ex: select name, curosr(select sum(quantity) from tablename where date between(pick a date) and (pick another date)) as 01, curosr(select sum(quantity) from tablename where date between(pick a date) and (pick another date)) as 02, curosr(select sum(quantity) from tablename where date between(pick a date) and (pick another date)) as 03, from tablename; thanks should give you the output you described below. Again, I am not sure if this is SQL Standard or just a function that Oracle offers. jim Bronx wrote:
--
Jim
Bagley www.Employmentguide.com -
Bringing Employers
and Jobseekers Together. |
- [ADMIN] Is it possible in PostgreSQL? Bronx
- [EMAIL PROTECTED]