On Mon, 2008-06-23 at 10:18 +0900, ITAGAKI Takahiro wrote:
> You need to do so in 8.3:
> EXECUTE 'INSERT INTO ' || ctable ||
> ' VALUES( (' || quote_literal(new) || '::' || ptable ||
> ').*)';
>
> In 8.4, the next release, you will be able to use a better way:
> EXECUTE 'INSERT INTO ' || ctable || ' VALUES( ($1).* )' USING new;
Domo arigato, Itagaki-san. (I think I got that right.)
The 8.3 method works like a charm.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0