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