Search Postgresql Archives

Re: dynamic insert in plpgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2010/1/9 Dimitri Fontaine <dfontaine@xxxxxxxxxxxx>:
> Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> writes:
>
>> Is there any nice way to do something like that in plpgsql:
>>
>>   EXECUTE 'INSERT INTO '||partition_table_name||' VALUES'||(NEW.*)||'';
>
> See http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers
> --

that approach is awful.  Sam's method (or the one I posted in the same
thread using dollar quoting) is much faster/better.

merlin

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux