I am using a DO$$ $$ block to emulate something that admittedly may be
standard practice to accomplish using psql but for which I am using a less
capable UI.
Anyway, the basic form is:
DO $$
DECLARE some_var varchar := 'value';
BEGIN
UPDATE ..... WHERE col = some_var;
UPDATE ..... WHERE col = some_var;
RETURN;
END;
$$
Now because of the DO I have no idea how many records were affected for each
of the UPDATE statements. I am thinking that, either at the statement-level
or even somehow defined inside the DO, some way to have the system
automatically echo the usual "0 records updated" message out of the DO.
i.e., UPDATE (VERBOSE) .... SET id = some_var;
GET DIAGNOSTICS obviously works, and for a stored function is probably the
better option, but for a simple DO oriented script command it is quite
verbose.
There is a prior discussion (somewhere) regarding using STRICT without
RETURNING in similar situations to easily define when only one (and only
one) record is expected to be affected. This thought falls into the same
usability category.
Thoughts?
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Feature-Idea-Statement-Echo-in-DO-tp5762454.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.