I'm really trying to understand how the tablefunc crosstab function works, to no avail.
I have a table that looks like this: customer_id integer date timestamp with time zone amount numeric(10,4) There are rows in this table every-time a customer gets charged an amount, which is multiple times per day. I would like to get a result like this: customer_id,day1,day2,day3,(…) 1,400.00,500.01,123.00,(…) So, one row for each customer id and a column for every day in the current month. Anyone used crosstab for something like this? Thanks for your help, A. -- www.sherman.ca / +1-613-797-6819 / +1-646-233-3400 "When the burning husks of your startups warm the last of your bones, remember I told you so." - Zed -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
