BUG #2230: cannot return a setof column referenced types

Started by Murat Tasanabout 20 years ago2 messagesbugs
Jump to latest
#1Murat Tasan
murat.tasan@cwru.edu

The following bug has been logged online:

Bug reference: 2230
Logged by: Murat Tasan
Email address: murat.tasan@cwru.edu
PostgreSQL version: 8.1.2
Operating system: Mac OS 10.4.4
Description: cannot return a setof column referenced types
Details:

Hi, I already heard from Tom Lane that this is a grammar oversight, and I
suspect it is a fairly easy fix... but to be somewhat formal I figured I'll
go ahead and fill the report:

During function creation, one cannot combine both SETOF and %TYPE.

For example:

CREATE FUNCTION temp_function() RETURNS SETOF table.column%TYPE AS %%
function_definition_here %% LANGUAGE SQL;

fails.

FYI.

Cheers!

Murat

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Murat Tasan (#1)
Re: BUG #2230: cannot return a setof column referenced types

"Murat Tasan" <murat.tasan@cwru.edu> writes:

During function creation, one cannot combine both SETOF and %TYPE.

Fixed here:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00396.php

regards, tom lane