Horton

Add support for \aset in pgbench

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 9d8ef98800bd291de145fb1be41f0868546e02ab
Author: Michael Paquier <michael@paquier.xyz>
Date: 2020-04-03T02:45:15Z
Releases: 13.0 
Add support for \aset in pgbench

This option is similar to \gset, except that it is able to store all
results from combined SQL queries into separate variables.  If a query
returns multiple rows, the last result is stored and if a query returns
no rows, nothing is stored.

While on it, add a TAP test for \gset to check for a failure when a
query returns multiple rows.

Author: Fabien Coelho
Reviewed-by: Ibrar Ahmed, Michael Paquier
Discussion: https://postgr.es/m/alpine.DEB.2.21.1904081914200.2529@lancre

Files

PathChange+/−
doc/src/sgml/ref/pgbench.sgml modified +18 −4
src/bin/pgbench/pgbench.c modified +41 −15
src/bin/pgbench/t/001_pgbench_with_server.pl modified +45 −0

Documentation touched

Discussion