Re: SELECT syntax synopsis: column_definition?

"Michael Glaesemann" <grzm(at)seespotcode(dot)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