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;
thanks, we're using version 8.3.7.
In response to
pgsql-general by date
|Next:||From: Pavel Stehule||Date: 2009-09-28 17:29:20|
|Subject: Re: Functions returning multiple rowsets|
|Previous:||From: John R Pierce||Date: 2009-09-28 17:08:20|
|Subject: Re: sync structures|