Michael Monnerie<michael(dot)monnerie(at)is(dot)it-management(dot)at> 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