Re: function accepting a row

From: tgrzej <tgrzej(at)aster(dot)pl>
To: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: function accepting a row
Date: 2005-08-11 10:20:17
Message-ID: AF15F55EB4DCDE072CC694F7502DC0D9112375561227EF345422B300B5BC@webmail.aster.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Od: Michael Fuhr <mike(at)fuhr(dot)org>
..
> * 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.
>
Thanks for the answer,
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?

Tomek Grzejszczyk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Surabhi Ahuja 2005-08-11 10:34:00 regarding isolation between threads
Previous Message Martijn van Oosterhout 2005-08-11 10:00:13 Re: regarding isolation between threads