Re: BUG #2749: Function's final statement must be a SELECT - Mailing list pgsql-bugs

"Hagen" <sixtus@gmail.com> writes:
> create function test(text) returns table as $sql$
>   insert into table(value) values($1) returning *;
> $sql$ language sql;

> really should work now,

No doubt, but it's not happening for 8.2.  See thread here:
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00665.php
There's a lot more to it than meets the eye :-(

            regards, tom lane