On Thu, 2006-12-07 at 14:02 -0800, BigSmoke wrote: > I'm facing a particular task for which I need any procedural language > but PL/PgSQL. I can't use PL/PgSQL because it doesn't allow me to use > local variables such as new and old from a dynamic command. PLPerl. And I say this as someone who doesn't even like Perl. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate