Re: computed values in plpgsql

[Reid Thompson <reid.thompson@xxxxxxxx>]

On Mon, 2009-09-28 at 12:42 -0400, Merlin Moncure wrote:

> the best way to do this is very version dependent.  the basic trick is
> to use text cast to pass a composite type into the query sting.
> 
> one way:
> execute 'insert into foo_something select (' || new::text || '::foo).*';
> 
> you can try:
> execute 'insert into foo_something select ($1::foo).*' using new::text;
> 
> merlin

thanks,  we're using version 8.3.7.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general