Re: function accepting a row

On Wed, Aug 10, 2005 at 08:01:13PM +0200, Tomek Grzejszczyk wrote:
> I'am trying to create a function in plpgsql that will accept a parameter
> of type rowtype. Here is a little test script I wrote:
> http://62.121.81.182/pub/test_func.sql
>
> It works on Postgres 8.03, but fails on 7.4, where I actually want it to
> work. What am I doing wrong?

Wanting it to work isn't going to change the fact that 8.0 has better
support for composite types than previous versions. See the 8.0 Release
Notes:

http://www.postgresql.org/docs/8.0/static/release-8-0.html

One of the items under "Server-Side Language Changes" is:

* 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.

If you're using a version older than 8.0 then you'll have to work
within its limitations.

--
Michael Fuhr