Re: UPDATE w/ subselect doing locking - Mailing list pgsql-general

From Stephan Szabo
Subject Re: UPDATE w/ subselect doing locking
Date
Msg-id 20011115065718.T7025-100000@megazone23.bigpanda.com
Whole thread Raw
In response to UPDATE w/ subselect doing locking  (David Ford <dford@erisksecurity.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: tony
Date:
Subject: Re: Serial data type not starting at 1
Next
From: Tielman J de Villiers
Date:
Subject: Re: Serial data type not starting at 1