\set d sqrt(1 + random(1000) * 17)
\echo :d
sqrt(1+random(1000)*17)
I assume we want to keep that pre-existing behavior of \set in
psql,
Ok. So no interpreted expression ever in psql's \set for backward
compatibility.
that is, making a copy of that string and associating a name to it,
whereas I guess pgbench computes a value from it and stores that value.
Actually it stores the parsed tree, ready to be executed.
--
Fabien.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers