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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
