Hello all,
Forgive my ignorance. I'm trying to understand the RULES in PostgreSQL and
I have several questions. Why the rules if they are not part of SQL92 or
SQL3? Where do they come from? Are they from before the SQL history of
Postgres? Many things that can be done with RULES can be done with
TRIGGERS even where there is no FOR STATEMENT in the CREATE TRIGGER
statement of PostgreSQL. Are the rules in PostgreSQL, mainly, to implement
VIEWS, so they are some kind of intermediate step between the parser and
the optimizer?
TIA, Jesus.