Crosstab question

Dear list,

I recently discovered the crosstab function in postgresql.

What I'm trying to accomplish is turn this:

Suppliernumber Productnumber Price

0 2 0.8

0 3 1.2

1 2 0.9

1 3 1.1

Into this:

Productnumber Supplier1 Supplier2

2 0.8 0.9

3 1.2 1.1

The problem is that the data is being shifted when there is no
price for Supplier1 for product 3:

Productnumber Supplier1 Supplier2

2 0.8 0.9

3 1.1(WRONG!)

I'm using this command to retrieve the data:

select * from crosstab('select int_artnr, int_crednr, flt_inkoopprijs from
artcredinkoopprijzen where

int_crednr = 2 OR int_crednr = 3') as c(int_artnr integer, supp1 float4,
supp2

float4);

Am I doing something wrong or is this a limitation of the function?

With kind regards,

Paul