Re: function accepting a row

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: tgrzej <tgrzej(at)aster(dot)pl>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: function accepting a row
Date: 2005-08-11 13:07:42
Message-ID: 20050811130742.GA91088@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 11, 2005 at 12:20:17PM +0200, tgrzej wrote:
> I tried to follow #37.1.2 from:
> http://www.postgresql.org/docs/7.4/interactive/plpgsql.html
>
> where one can read:
> "Functions written in PL/pgSQL can accept as arguments any scalar or
> array data type supported by the server, and they can return a result
> of any of these types. They can also accept or return any composite
> type (row type) specified by name."
>
> So is this part of documentation non correct or is my way of calling a
> function accepting a rowtype is not correct?

PL/pgSQL functions can *accept* these types of arguments, but in
versions earlier than 8.0 they have trouble *passing* such arguments
to another function. The documentation should probably be more clear
about that.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-08-11 13:16:12 Re: 5 new entries for FAQ
Previous Message Jeff Boes 2005-08-11 12:45:33 Re: World-wide Stop Order on PERL,Python,Java::->> Use