Re: Passing composite values to functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jatinder Sangha" <Jatinder(at)sanghaservices(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Passing composite values to functions
Date: 2004-02-15 18:38:40
Message-ID: 9490.1076870320@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Jatinder Sangha" <Jatinder(at)sanghaservices(dot)co(dot)uk> writes:
> I'm having trouble passing a composite variable to a function.

AFAIK, plpgsql doesn't support this --- it doesn't have any way to pass
a row or record variable as a parameter to the main executor. Possibly
this will get fixed someday; I don't know of anyone working on it now
though.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dana Hudes 2004-02-15 18:44:46 Re: bytea or blobs?
Previous Message Stephan Szabo 2004-02-15 16:41:57 Re: [SQL] 7.4 - FK constraint performance