Обсуждение: Variable referencing itself in example of pgbench.sgml

Hi all,

While looking at some recent commit related to pgbench I noticed this
example in the docs:
\set aid (1021 * :aid) % (100000 * :scale) + 1
This actually would fail because aid references itself.

Attached is a patch to change this example as follows:
-\set aid (1021 * :aid) % (100000 * :scale) + 1
+\set aid (1021 * :ntellers) % (100000 * :scale) + 1
Regards,
--
Michael

On Thu, Mar 19, 2015 at 7:20 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> While looking at some recent commit related to pgbench I noticed this
> example in the docs:
> \set aid (1021 * :aid) % (100000 * :scale) + 1
> This actually would fail because aid references itself.

There's no special prohibition against that.  It works fine if aid is
already set.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company