Re: plpgsql - Insert from a record variable? - Mailing list pgsql-sql

From Tom Lane
Subject Re: plpgsql - Insert from a record variable?
Date
Msg-id 8648.1087867849@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql - Insert from a record variable?  ("Phil Endecott" <spam_from_postgresql_sql@chezphil.org>)
List pgsql-sql
"Phil Endecott" <spam_from_postgresql_sql@chezphil.org> writes:
> I think what I really need is an introspection mechanism
> so that I can loop over each element of the record and construct the
> insert as a string.  Maybe this is possible using a different
> server-side language?

pltcl can probably handle this; I'm less sure about plperl or plpython.
(No reflection on the languages, but pltcl has the most complete
Postgres interface.)
        regards, tom lane


pgsql-sql by date:

Previous
From: basic
Date:
Subject: Re: plpgsql - Insert from a record variable?
Next
From: Gary Stainburn
Date:
Subject: Re: subselect prob in view