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