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

From Hagen
Subject BUG #2749: Function's final statement must be a SELECT
Date
Msg-id 200611091007.kA9A7NuU021604@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2749: Function's final statement must be a SELECT
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2749
Logged by:          Hagen
Email address:      sixtus@gmail.com
PostgreSQL version: 8.2beta2
Operating system:   OSX
Description:        Function's final statement must be a SELECT
Details:

create function test(text) returns table as $sql$
  insert into table(value) values($1) returning *;
$sql$ language sql;


really should work now, instead I get:
PGError: ERROR:  return type mismatch in function declared to return table
DETAIL:  Function's final statement must be a SELECT.

pgsql-bugs by date:

Previous
From: ""
Date:
Subject: BUG #2745: upgrade.bat refers to msi file name for version 8.1 ms
Next
From: Tom Lane
Date:
Subject: Re: BUG #2742: psql -c is not case sensitive