| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
| Cc: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: possible typo on 8.2 manual |
| Date: | 2007-02-01 19:20:45 |
| Message-ID: | 200702011920.l11JKjQ09902@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John D. Burger | 2007-02-01 19:40:11 | Fwd: How to allow users to log on only from my application |
| Previous Message | Bruno Wolff III | 2007-02-01 19:19:41 | Re: What's the best way to index this table for speed? |