Re: Returning composite types from a plpgsql function

Joseph Barillari <jbarilla(at)princeton(dot)edu> writes:
> Unfortunately, when I execute this, I get:

> cal=3D> select frob();
> frob=20=20=20=20
> -----------
> 172795360
> (1 row)

You can't do anything useful with a rowtype function result except
select a single field from it. The manual's discussion for SQL
functions also applies to PL-language functions:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/xfunc-sql.html#AEN26354

There is work afoot to allow
SELECT ... FROM function(...)
which would make functions returning rowtypes a whole lot more useful.

regards, tom lane