From: | elein <elein(at)varlena(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | elein <elein(at)varlena(dot)com>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: obtuse plpgsql function needs |
Date: | 2003-07-23 19:27:23 |
Message-ID: | 20030723122723.C26401@cookie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)varlena(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | greg | 2003-07-23 19:38:47 | Re: obtuse plpgsql function needs |
Previous Message | Tom Lane | 2003-07-23 19:15:50 | Re: obtuse plpgsql function needs |