On Mon, Sep 28, 2009 at 1:29 PM, Reid Thompson <reid.thomp...@ateb.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general