BUG #2230: cannot return a setof column referenced types

Поиск
Список
Период
Сортировка
От Murat Tasan
Тема BUG #2230: cannot return a setof column referenced types
Дата
Msg-id 20060131195549.691C9F0B00@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2230: cannot return a setof column referenced types  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: [PATCHES] BUG #2221: Bad delimiters allowed in COPY ...
Следующее
От: Patrick Rotsaert
Дата:
Сообщение: Re: BUG #2225: Backend crash -- BIG table