ERROR: a column definition list is required for functions returning "record"

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: a column definition list is required for functions returning "record"
Date: 2007-07-17 09:56:52
Message-ID: 000801c7c858$d1f3edd0$88ae0fd4@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a plpgsql function that returns dataset.
First it was defined to return SETOF someview.
Then I changed it to return SETOF RECORD, in order to be able to return dataset with varying number of columns.
But, I get the following error:"ERROR: a column definition list is required for functions returning "record" SQL state: 42601".
What does it mean? What is "columns definition list"?

Thanks,

Zlatko

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-07-17 10:14:14 Re: interaction with postgres defined types in custom c functions
Previous Message Tim Tassonis 2007-07-17 09:46:00 Re: The speed problem of Varchar vs. Char