Affected rows count by rule as condtition

Поиск
Список
Период
Сортировка
Hi,
is there any way how to count affected rows by on update rule and use it 
as part of condtions.

Example:


CREATE OR REPLACE RULE "_UPDATE" AS ON UPDATE TO "users" DO INSTEAD (   UPDATE "s_users" SET    id = new.id,
login= new.login,   WHERE id IN (SELECT id FROM "s_users" ) AND 2 > (SELECT count(new.id)) ;
 

Error: agregate functions not allowed in WHERE statement

It need to simulate unique constraint on field s_users.new_id, so it 
should deny to update multiple rows with same value.

Any suggestions are welcome.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: Solution of the file name problem of copy on windows.
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: Affected rows count by rule as condtition