Re: Functions returning RECORD

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Craig Bryden <postgreSQL(at)bryden(dot)co(dot)za>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Functions returning RECORD
Date: 2005-01-13 20:55:09
Message-ID: 20050113125223.F32237@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Frank D. Engel, Jr. 2005-01-13 21:04:51 Re: best place to enfore rules
Previous Message Mike G. 2005-01-13 20:44:30 Cursor bug?