Re: Passing a ROWTYPE to a function - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Passing a ROWTYPE to a function
Date
Msg-id 20050105165037.GA25149@winnie.fuhr.org
Whole thread Raw
In response to Passing a ROWTYPE to a function  (Eric Brown <eric.brown@propel.com>)
List 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 by date:

Previous
From: Wes
Date:
Subject: Re: hundreds of millions row dBs
Next
From: "John Doggett"
Date:
Subject: problem finding the 8.0.3RC download