Michael Monnerie<michael.monnerie@xxxxxxxxxxxxxxxxxxx> wrote: > But that is error prone, because when the "filter" table is > changed to have a new column, the UPDATE statement would not > contain it. Is there a fail-proof shortcut? You might draw inspiration for a C-based solution from Andrew Dunstan's "minimal update" code. A quick search turned up this, but you might want to read the whole thread and look for possible later versions of the code: http://archives.postgresql.org/pgsql-hackers/2008-10/msg01111.php -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin