Re: computed values in plpgsql

On Mon, Sep 28, 2009 at 1:29 PM, Reid Thompson <reid(dot)thompson(at)ateb(dot)com> wrote:
> 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.

'execute using' is 8.4 feature. so you have to use the string
concatenation approach. let me fix the errors:

execute 'insert into foo_something select (''' || new::text || '''::foo).*';

:-)

merlin