Re: Function and RowType

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carlos Roberto Chamorro Mostacilla <carlosrchamorro(at)yahoo(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Function and RowType
Date: 2004-07-14 14:31:44
Message-ID: 26561.1089815504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?q?Carlos=20Roberto=20Chamorro=20Mostacilla?= <carlosrchamorro(at)yahoo(dot)com> writes:
> --IT DOES NOT WORK
> 10. PERFORM probar_record(reg);

Nope. plpgsql is pretty limited in what it can do with a rowtype
variable, and one thing it cannot do is pass the entire row into
an SQL expression.

This is fixed in CVS tip, for what that's worth.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcos Medina 2004-07-14 15:13:40 FOR-IN-EXECUTE, why fail?
Previous Message pdvluca 2004-07-14 14:08:12 Triggers called twice, triggers debugging