[ADMIN] Is it possible in PostgreSQL?

[Bronx]

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