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@xxxxxxxxxx EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
