Re: obtuse plpgsql function needs
От
elein
Тема
Re: obtuse plpgsql function needs
Дата
Msg-id
20030723122723.C26401@cookie
Ответ на
Re: obtuse plpgsql function needs (Tom Lane)
Список
Дерево обсуждения
obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: obtuse plpgsql function needs Josh Berkus <josh@agliodbs.com>
Re: obtuse plpgsql function needs elein <elein@varlena.com>
Re: obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: obtuse plpgsql function needs elein <elein@varlena.com>
Re: obtuse plpgsql function needs Tom Lane <tgl@sss.pgh.pa.us>
Re: obtuse plpgsql function needs elein <elein@varlena.com>
Re: obtuse plpgsql function needs Tom Lane <tgl@sss.pgh.pa.us>
Re: obtuse plpgsql function needs elein <elein@varlena.com>
Re: obtuse plpgsql function needs Josh Berkus <josh@agliodbs.com>
Re: obtuse plpgsql function needs greg@turnstep.com
Re: obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: obtuse plpgsql function needs Josh Berkus <josh@agliodbs.com>
TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat <xzilla@users.sourceforge.net>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus <josh@agliodbs.com>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Richard Poole <richard@ruthie.org>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus <josh@agliodbs.com>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus <josh@agliodbs.com>
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian <pgman@candle.pha.pa.us>
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 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 по дате отправления