UPDATE w/ subselect doing locking
От | David Ford |
---|---|
Тема | UPDATE w/ subselect doing locking |
Дата | |
Msg-id | 3BF21E9B.4060106@erisksecurity.com обсуждение исходный текст |
Ответы |
Re: UPDATE w/ subselect doing locking
Re: UPDATE w/ subselect doing locking |
Список | pgsql-general |
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? Thank you, David
В списке pgsql-general по дате отправления: