Skip site navigation (1) Skip section navigation (2)

Re: plpgsql - Insert from a record variable?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phil Endecott" <spam_from_postgresql_sql(at)chezphil(dot)org>
Cc: "Riccardo G(dot) Facchini" <abief_ag_-postgresql(at)yahoo(dot)com>,pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql - Insert from a record variable?
Date: 2004-06-22 01:30:49
Message-ID: 8648.1087867849@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
"Phil Endecott" <spam_from_postgresql_sql(at)chezphil(dot)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

In response to

pgsql-sql by date

Next:From: Gary StainburnDate: 2004-06-22 09:34:10
Subject: Re: subselect prob in view
Previous:From: basicDate: 2004-06-22 00:57:19
Subject: Re: plpgsql - Insert from a record variable?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group