By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,044 Members | 1,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,044 IT Pros & Developers. It's quick & easy.

crosstab error 'query-specified return row and actual function return do not...

P: n/a
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
Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.