Re: [GENERAL] rules and rows affected

2007-08-30 Thread Tom Lane
"Roberto Icardi" <[EMAIL PROTECTED]> writes: > Everything works perfectly... BUT the query returns always 0 rows affected, > even if one record is inserted or deleted in friends_hobbies...why?? The rules for this are explained here: http://www.postgresql.org/docs/8.2/static/rules-status.html If

[GENERAL] rules and rows affected

2007-08-30 Thread Roberto Icardi
Hi all... I'm experimenting for the first time with rules to make a view updatable, but I've found a strange "effect"... I'll try to explain what I'm trying to achieve Suppose I have a table "friends" and a table "hobbies". Each friend can be interested in one or more hobbies: CREATE TABLE fr