diff options
Diffstat (limited to 'sql/triggers.sql')
-rw-r--r-- | sql/triggers.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/triggers.sql b/sql/triggers.sql index eeb0c411..bfda6354 100644 --- a/sql/triggers.sql +++ b/sql/triggers.sql @@ -299,7 +299,7 @@ BEGIN UPDATE reviews SET c_count = COALESCE((SELECT COUNT(*) FROM reviews_posts WHERE NOT hidden AND id = reviews.id), 0) , c_lastnum = (SELECT MAX(num) FROM reviews_posts WHERE NOT hidden AND id = reviews.id) - WHERE id IN(OLD.tid,NEW.tid); + WHERE id IN(OLD.id,NEW.id); RETURN NULL; END $$ LANGUAGE plpgsql; |