Re: BUG #2749: Function's final statement must be a SELECT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hagen" <sixtus(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2749: Function's final statement must be a SELECT
Date: 2006-11-10 06:29:13
Message-ID: 16686.1163140153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Hagen" <sixtus(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dennis 2006-11-10 09:22:58 BUG #2751: contrib\pgxml.sql
Previous Message Tom Lane 2006-11-10 06:17:48 Re: BUG #2742: psql -c is not case sensitive