I also don't like to restate what has already been said. \set at the
beginning of the line tells you that you will be setting a variable.
Adding = or := only restates the same thing. I agree it superficially
looks a little nicer, but I'm not sure it's really going to add
clarity, because it's basically just redundant.
Ok. I've marked this one as REJECTED.
Otherwise, I was considering this kind of things:
n := expr
If we have functions, that could include:
n := random(1, 100)
with more work (handling of double constants):
n := exprandom(1, 100, 3.5)
and maybe:
n := SELECT ...
or even:
n, m, p, q := SELECT ...
Also, having ";" as a end of commands could also help by allowing
multiline commands, but that would break compatibility. Maybe allowing
continuations (\\\n) would be an acceptable compromise.
--
Fabien.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers