Re: SELECT syntax synopsis: column_definition?

"Michael Glaesemann" <grzm@seespotcode.net> writes:

> ERROR:  a column definition list is only allowed for functions  returning
> "record"
>
> So the *form* is right, but I don't know of an example that works.

postgres=# create function testf() returns record as 'select 1' language sql;
CREATE FUNCTION
postgres=# select * from testf() as (i integer);i 
---1
(1 row)


I haven't quite figured out how this is useful though. It probably makes more
sense if you use plpgsql but I still don't quite see what the use case is.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com