possible typo on 8.2 manual

Started by Richard Broersma Jrover 19 years ago2 messagesgeneral
Jump to latest
#1Richard Broersma Jr
rabroersma@yahoo.com

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.

#2Bruce Momjian
bruce@momjian.us
In reply to: Richard Broersma Jr (#1)
Re: possible typo on 8.2 manual

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. +