Richard Broersma Jr wrote:
> 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
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. +