Re: obtuse plpgsql function needs - Mailing list pgsql-sql

From elein
Subject Re: obtuse plpgsql function needs
Date
Msg-id 20030723122723.C26401@cookie
Whole thread Raw
In response to Re: obtuse plpgsql function needs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: obtuse plpgsql function needs
List pgsql-sql
So, other than C, plperl or pltcl is the way to go.
As long as they can input generic composite types
(I wasn't sure of that, but I should have known), 
they can access columns as array elements so you can
loop through them. And they'll tell you the number
of arguments. Ta da!

elein

On Wed, Jul 23, 2003 at 03:15:50PM -0400, Tom Lane wrote:
> elein <elein@varlena.com> writes:
> > You can do it in C, of course.
> 
> Yeah.  Also you could do it easily in plperl or pltcl (composite-type
> arguments get passed as perl hashes or Tcl arrays respectively).
> plpgsql does not have any facility for run-time determination of field
> names, so you're pretty much out of luck in that particular language.
> 
>             regards, tom lane
> 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: obtuse plpgsql function needs
Next
From: greg@turnstep.com
Date:
Subject: Re: obtuse plpgsql function needs