Thread: possible typo on 8.2 manual

possible typo on 8.2 manual

From
Richard Broersma Jr
Date:
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.

Re: possible typo on 8.2 manual

From
Bruce Momjian
Date:
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. +