Re: Plpgsql problem passing ROWTYPE to function - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: Plpgsql problem passing ROWTYPE to function
Date
Msg-id 20040430102630.E18712@mofo.meme.com
Whole thread Raw
In response to Re: Plpgsql problem passing ROWTYPE to function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Foreign Key ON DELETE CASCADE Performance
List pgsql-general
On 2004.04.29 22:21 Tom Lane wrote:

> >   "Parameters to a function can be composite types (complete table
> > rows). In that case, the corresponding identifier $n will be a row
> > variable, and fields can be selected from it, for example
> $1.user_id."
>
> That says that a parameter passed *into* a plpgsql function can be a
> rowtype, not that plpgsql supports doing something with the whole-row
> variable in function calls it makes.

I'm afriad I don't understand.

I don't want to have a plpgsql function write a plpgsql function,
all I want to do is have a plpgsql function call a plpgsql function,
pass it a ROWTYPE variable and read the 'column' values of
the ROWTYPE variable in the called function.  What use is it to be able
to write
a plpgsql function that receives a ROWTYPE variable if you can't
call the function from plpgsql?

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

pgsql-general by date:

Previous
From: Martin Marques
Date:
Subject: Re: Calls to find Users and databases open...
Next
From: Bruno Wolff III
Date:
Subject: Re: target list evaluation wrt sequences