\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

Reply via email to