Question posted by: M Fadhilah via DBMonster.com
(Guest)
on
November 23rd, 2005 02:04 AM
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
Not the answer you were looking for? Post your question . . .
183,962 Experts ready to help you find a solution.
Sign up for a free account, or
Login (if you're already a member).
