|
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
| 
