Re: UPDATE w/ subselect doing locking

On Wed, 14 Nov 2001, David Ford wrote:

> Would someone mind setting my head on straight with a proper query
> please. Here is my table and the query I have thusfar. I need it to
> match and update specifically only the string I specify for the regex.
>
> bluelist=> select * from spamcontrol;
> id | logical group | count | add time | added
> by | regex | comment
> ----+---------------+-------+-------------------------------+----------------+-----------------------------------------------+---------
> | | 5 | 2001-11-12 00:09:41.326116-05 |
> 208.179.59.203 | MERCATI FINANZIARI |
> | | 5 | 2001-11-12 00:10:24.292267-05 |
> 208.179.59.203 | setup fees |
>
>
> bluelist=> UPDATE spamcontrol SET count=foo.count+1 FROM (SELECT count
> FROM spamcontrol WHERE regex='setup fees' FOR UPDATE) as foo;
>
> How do I get it to only update that one row?

Wouldn't update spamcontrol set count=count+1 where regex='setup fees';
do the same thing or am I missing something?