Re: Is it possible in PostgreSQL?

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:

Hi,

I've got problem with one specific query. I've got the table

with many of rekords like these:

 

name     |  quantity    | date

-------------------------------------------------------

aaa            2                2003-04-01

bbb            4                2003-04-12

ccc            5                2003-05-12

aaa            3                2003-01-14

aaa            1                2003-12-09

bbb            9                2003-08-08

 

and so on ...

 

Does anybody know how make query which return grouped

records by month of year and name (also sum of quantity).

It is possible to make a query whitch return something like that:

 

name | 01 | 02 | 03 | 04 | ... | 12 (months)

------------------------------------------------

aaa     x     x     x    x    ...   x

bbb     x     x     x    x    ...   x

ccc     x     x     x    x    ...   x

 

where x means sum of quantity in month.

It is possible to make it in one query?

I know that in Access is construction : PIVOT.

 

Thanks

Adam