possible typo on 8.2 manual
on the link:
http://www.postgresql.org/docs/8.2/static/rules-update.html
you will notice that from items are repeated. Is this correct?
...
FROM shoelace_arrive shoelace_arrive, shoelace_ok shoelace_ok,
shoelace_ok *OLD*, shoelace_ok *NEW*,
shoelace shoelace, shoelace *OLD*,
shoelace *NEW*, shoelace_data shoelace_data
...
Regards,
Richard Broersma Jr.
Richard Broersma Jr wrote:
on the link:
http://www.postgresql.org/docs/8.2/static/rules-update.htmlyou will notice that from items are repeated. Is this correct?
...
FROM shoelace_arrive shoelace_arrive, shoelace_ok shoelace_ok,
shoelace_ok *OLD*, shoelace_ok *NEW*,
shoelace shoelace, shoelace *OLD*,
shoelace *NEW*, shoelace_data shoelace_data
This example has an alias for every table reference. The ones where the
table reference and alias are the same, like "shoelace_ok shoelace_ok"
are not necessary and could be written just as "shoelace_ok", but either
is OK.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +