| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | y(dot)saburov(at)gmail(dot)com |
| Subject: | Check query |
| Date: | 2026-06-26 14:37:56 |
| Message-ID: | 178248467618.108999.9966122434342474006@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/rules-views.html
Description:
Please check that the condition in the query is correct.
> 39.2.1. How SELECT Rules Work
Similarly, the rules for shoe and shoelace are substituted into the range
table of the subquery, leading to a three-level final query tree:
SELECT shoe_ready.shoename, shoe_ready.sh_avail,
shoe_ready.sl_name, shoe_ready.sl_avail,
shoe_ready.total_avail
...
...
WHERE shoe_ready.total_avail > 2; ??? (maybe WHERE shoe_ready.total_avail
>= 2;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2026-06-27 15:51:09 | Re: Check query |
| Previous Message | Fujii Masao | 2026-06-25 16:46:41 | Document COPY FROM WHERE restrictions on generated and system columns |