Postgres Pro
Downloads
Home   >   mailing lists

ERROR: a column definition list is required for functions returning "record" - Mailing list pgsql-general

From Zlatko Matić
Subject ERROR: a column definition list is required for functions returning "record"
Date
Msg-id 000801c7c858$d1f3edd0$88ae0fd4@zlatkovyfkpgz6
Whole thread Raw
Responses Re: ERROR: a column definition list is required for functions returning "record"  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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
 

pgsql-general by date:

Previous
From: Nis Jørgensen
Date:
Subject: Re: pg_dump without blobs
Next
From: "Pavel Stehule"
Date:
Subject: Re: ERROR: a column definition list is required for functions returning "record"