Re: Passing a ROWTYPE to a function

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Passing a ROWTYPE to a function
Дата
Msg-id 20050105165037.GA25149@winnie.fuhr.org
обсуждение исходный текст
Ответ на Passing a ROWTYPE to a function  (Eric Brown <eric.brown@propel.com>)
Список pgsql-general
On Wed, Jan 05, 2005 at 05:04:03AM -0800, Eric Brown wrote:

> I'm trying to write a function that takes a %ROWTYPE as an argument.

The code you posted works in 8.0.  Here's an item from the 8.0
Release Notes:

* More support for composite types (row and record variables) in PL/pgSQL

  For example, it now works to pass a rowtype variable to another
  function as a single variable.

I don't think you could do this in versions prior to 8.0; see
previous discussion in the list archives.  For example:

http://archives.postgresql.org/pgsql-general/2004-03/msg00862.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

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

Предыдущее
От: Wes
Дата:
Сообщение: Re: hundreds of millions row dBs
Следующее
От: "John Doggett"
Дата:
Сообщение: problem finding the 8.0.3RC download