Re: Functions returning RECORD - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Functions returning RECORD
Date
Msg-id 20050113125223.F32237@megazone.bigpanda.com
Whole thread Raw
In response to Functions returning RECORD  ("Craig Bryden" <postgreSQL@bryden.co.za>)
List pgsql-general
On Thu, 13 Jan 2005, Craig Bryden wrote:

> When I run select * from GetAccountInfo (100)

> I get the following error message: ERROR:  a column definition list is
> required for functions returning "record"

You need to say something like:
select * from GetAccountInfo(100) AS foo(field1 int, field2 int, field4
text);

Where the types match appropriately.


pgsql-general by date:

Previous
From: "Mike G."
Date:
Subject: Cursor bug?
Next
From: "Frank D. Engel, Jr."
Date:
Subject: Re: best place to enfore rules