Dear All,

I am newbie in postgresql, i am using postgressql 8.0 for windows and i try
using crosstab for my table.
my table structure is

account_id text
account_parent text
account_level int

and i want my quey output like this

account_id level1_parent, level2_parent, level3_parent

but if i query crosstab using this parameter

select * from crosstab('select account_id,account_level,account_parent'
from account',3) as x(account_id text,level1_parent text,level2_parent
text,level3_parent text)

I always got 'query-specified return row and actual function return row do
not match' error..

Can anybody help me..?

best regards

M. Fadhilah