Re: dynamic insert in plpgsql

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/