Re: Record as a parameter to a function

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Carlos Correia <carlos(at)m16e(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Record as a parameter to a function
Date: 2005-04-22 11:14:06
Message-ID: 20050422111406.GA50123@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 22, 2005 at 03:31:59AM +0100, Carlos Correia wrote:
> Michael Fuhr wrote:
> | On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
> |
> |>carlos=# insert into test (c1) values( 'test');
> |>ERROR: NEW used in query that is not in a rule
> |>CONTEXT: PL/pgSQL function "tftest" line 2 at perform
> |
> | PostgreSQL 8.0 and later have improved support for composite types.
>
> Thanks... but does this means that you can't do that with version 7.4.x?

Not as far as I know, or at least not the same way.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Kirkbride 2005-04-22 12:50:42 Optimising Union Query.
Previous Message Michael Fuhr 2005-04-22 11:11:21 Re: Table modifications with dependent views - best practices?