On 2025/06/26 18:01, Yugo Nagata wrote:
> 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.
Right.
> Therefore, I’ve attached a patch to remove this part from the documentation.
Or would it be worth documenting an alternative way to detect when no rows are
returned? For example:
If a query returns no rows, no variables are assigned. You can detect
this by setting an initial value to the variable before running the query
and checking whether it changes.
Regards,
--
Fujii Masao
NTT DATA Japan Corporation
