Postgres Pro
Downloads
Home   >   mailing lists

Re: How to manually load RETURNS SETOF RECORD? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How to manually load RETURNS SETOF RECORD?
Date
Msg-id 18654.1449604149@sss.pgh.pa.us
Whole thread Raw
In response to How to manually load RETURNS SETOF RECORD?  (Michael Moore <michaeljmoore@gmail.com>)
List pgsql-sql
Tree view 
Michael Moore <michaeljmoore@gmail.com> writes:
> *What is the correct way to accomplish this?*

Something like RETURN NEXT ROW('foo', 200, ...);
Or you could assign the ROW construct to a variable of RECORD type.
        regards, tom lane

pgsql-sql by date:

Previous
From: Michael Moore
Date:
Subject: How to manually load RETURNS SETOF RECORD?
Next
From: Adrian Klaver
Date:
Subject: Re: How to manually load RETURNS SETOF RECORD?