Thread: columnar format

good day!

i would like to ask for the sql statement to the output:

ITEM DESC   Jan   Feb   Mar  Apr  ...  Sep  Total
xxxxxxxxxx   999  999  999  999  ...  999  9,999

where "Jan" column is sum of all "x" items purchased on Jan, "Feb" column as 
sum of Feb purchases, and so on up to "Sep", and "Total" as the total from 
"Jan" to "Sep" (as in the case here). the numbers may/may not be formatted, 
and the period varies, depending on the range.

your help will be much appreciated.

thanks!�

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus

>
> i would like to ask for the sql statement to the output:
>
> ITEM DESC   Jan   Feb   Mar  Apr  ...  Sep  Total
> xxxxxxxxxx   999  999  999  999  ...  999  9,999
>
> where "Jan" column is sum of all "x" items purchased on Jan, "Feb"
column as
> sum of Feb purchases, and so on up to "Sep", and "Total" as the total
from
> "Jan" to "Sep" (as in the case here). the numbers may/may not be
formatted,
> and the period varies, depending on the range.
>
Search the archives for pivot tables resp. crosstab and/or have a look
at
$PGSQLD/contrib/tablefunc/README.tablefunc
Regards, Christoph