Re: returning result set

On Mon, Sep 22, 2008 at 2:40 PM, Gohil, Hemant <HGohil@dylt.com> wrote:

> For some reason I am not getting following error.
> ERROR: a column definition list is required for functions returning "record"

> CREATE FUNCTION function1(integer) RETURNS SETOF record AS $$

When you select from this function don't you have to also alias the
name of the SQL result and its columns?

SELECT * from function1( 2 ) AS myresult( colA, colB, colC, colD, colE );


Also, If I am not mistake, Functional alias also allow you to specify
datatypes correct?
http://www.postgresql.org/docs/8.3/interactive/sql-select.html


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug