| From: | Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Documentation fix on pgbench \aset command |
| Date: | 2025-06-26 09:01:25 |
| Message-ID: | 20250626180125.5b896902a3d0bcd93f86c240@sraoss.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
The current documentation of pgbench’s \aset command states:
“If a query returns no row, no assignment is made and the variable
can be tested for existence to detect this.”
However, this is inaccurate, since variable existence check (like \if :{?var})
is not yet supported, although such a feature was proposed in [1] and discussed
again in [2], where \aset itself was introduced.
Therefore, I’ve attached a patch to remove this part from the documentation.
[1] https://www.postgresql.org/message-id/flat/alpine.DEB.2.20.1802191909500.21372%40lancre
[2] https://www.postgresql.org/message-id/flat/alpine.DEB.2.21.1904081914200.2529%40lancre
Best regards,
Yugo Nagata
--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
| Attachment | Content-Type | Size |
|---|---|---|
| fix_doc_pgbench_aset.ptach | application/octet-stream | 915 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2025-06-26 09:23:38 | Re: Adding OLD/NEW support to RETURNING |
| Previous Message | Tomas Vondra | 2025-06-26 08:53:26 | Re: pgsql: Introduce pg_shmem_allocations_numa view |