On Fri, Jan 08, 2010 at 02:55:53PM +0000, Grzegorz Jaaakiewicz wrote: > Is there any nice way to do something like that in plpgsql: > > EXECUTE 'INSERT INTO '||partition_table_name||' VALUES'||(NEW.*)||''; > > It would probably work, but some values are NULL, and plpgsql > interpreter just puts empty space there. So I get ('1',2,3,,,); Which > obviously is confusing INSERT. Yup, this thing is a bit fiddly. Try: http://archives.postgresql.org/pgsql-general/2009-09/msg01176.php -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general