Unexpected output of PgRules
Manav Kumar <mkumar@yugabyte.com>
From: Manav Kumar <mkumar@yugabyte.com>
To: pgsql-bugs@lists.postgresql.org
Date: 2025-05-14T09:14:30Z
Lists: pgsql-bugs
Hi Team, I'm writing to clarify one of the expected output in rules.out file. Why does value at this line https://github.com/postgres/postgres/blob/913c60b067aa1a618420fd0372c4df3cf5501863/src/test/regress/expected/rules.out#L594 for rtest_t6 is zeros. When we have defined the rule for rtest_t6 as: create rule rtest_t4_ins2 as on insert to rtest_t4 where new.a >= 20 and new.a < 30 do insert into rtest_t6 values (new.a, new.b); Therefore: At https://github.com/postgres/postgres/blob/913c60b067aa1a618420fd0372c4df3cf5501863/src/test/regress/expected/rules.out#L576 / insert into rtest_t4 select * from rtest_t9 where b ~ 'and t8'; Shouldn't insert the rows with value as 26 and 28 as well. Isn't it ? as rules says to insert the rows in rtest_t6 tables if value is from 20(inclusive) to 30 (exclusive). Please help me with the clarification. Thanks Manav
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
doc: Small example improvement
- 913c60b067aa 18.0 cited