Re: UPDATE keyword - Mailing list pgsql-general

From Rene Pijlman
Subject Re: UPDATE keyword
Date
Msg-id 1frugtoiqu2i7r8fp9n0abmjia8mh7i20c@4ax.com
Whole thread Raw
In response to UPDATE keyword  ("Ian Harding" <ianh@healthdept.co.pierce.wa.us>)
List pgsql-general
ianh@healthdept.co.pierce.wa.us ("Ian Harding") schreef:
>UPDATE mytable SET myfield = myfield WHERE...
>to fire an update trigger, and executing only the code in that
>trigger surrounded by UPDATE(myfield).

So you update a field by not changing its value, to execute a piece of
code that has nothing to do with the field and the value :-)

>Is there an easy way to duplicate this, or should I work around it?

Isn't it easier (and more poratble) to add a dummy field to the table?
Then you can do:

   UPDATE mytable
   SET dummy = 1 - dummy
   WHERE ...

to execute the piece of code that responds to an update of 'dummy'.

Regards,
René Pijlman

http://www.applinet.nl

pgsql-general by date:

Previous
From: HYip
Date:
Subject: Re: PostgreSQL in Comparison to mySQL
Next
From: mordicus
Date:
Subject: Re: Functional Indices