[SQL] Passing composite values to functions

2004-02-15 Thread Jatinder Sangha
Hi,   I'm having trouble passing a composite variable to a function.   I have a composite as follows:       declare userRecord dnaUsers%ROWTYPE;   and I manipulate it like this:       select into userRecord * from dnaUsers where etc;     userRecord.userid := 'jatinder'; --etc     I would l

Re: [SQL] Passing composite values to functions

2004-02-15 Thread Tom Lane
"Jatinder Sangha" <[EMAIL PROTECTED]> 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 o