Rows to columns query

On Mon, 10 May 2004, mike wrote:

Does anyone know if this is feasable

I have two tables

one has inv_id,amount,date, cheque no

the second has
inv_id, amount , code (this relate to type of expenditure)

There is a one to many relationship on inv_id

What I want to do is

Group all the fields in the first table (easy), but then have the
grouped values in the 2nd table appearing as values in the columns ie

inv_id, cheque, amount_vote1,amount_vote2,amount_vote3 etc

See contrib/tablefunc's crosstab functions. You will need to know the
number of output columns in advance though.

Kris Jurka