| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Eric Brown <eric(dot)brown(at)propel(dot)com> |
| Cc: | PgSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Passing a ROWTYPE to a function |
| Date: | 2005-01-05 16:50:37 |
| Message-ID: | 20050105165037.GA25149@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Doggett | 2005-01-05 17:12:42 | problem finding the 8.0.3RC download |
| Previous Message | Wes | 2005-01-05 15:50:00 | Re: hundreds of millions row dBs |