View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 06:50 PM
Stephan Szabo
 
Posts: n/a
Default Re: Functions returning RECORD


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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote