Re: proposal: condition blocks in psql
| От | Pavel Stehule |
|---|---|
| Тема | Re: proposal: condition blocks in psql |
| Дата | |
| Msg-id | CAFj8pRCY-E87+=V52sYbpCfZmfbXD-CLZLhrb13K29B+k_U3Ew@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: proposal: condition blocks in psql (Tomas Vondra <tomas.vondra@2ndquadrant.com>) |
| Ответы |
Re: proposal: condition blocks in psql
|
| Список | pgsql-hackers |
2015-06-28 14:12 GMT+02:00 Tomas Vondra <tomas.vondra@2ndquadrant.com>:
Hi,
On 06/28/2015 09:04 AM, Fabien COELHO wrote:2. The general difficulty of getting psql var values into a DO
block (currently I use temp tables).
Maybe this means that DO should be extended in some way to allow for
parameters, at least when PL/pgSQL is used?
I agree with this wholeheartedly. ISTM most of this thread is about limitations of our current DO implementation, partially addressed by adding a bunch of scripting commands, specific to psql. I don't think that's the right solution.
This proposal is not against to DO parametrization. It is same like conditional block in C (#ifdef). There is similarity with C statements - and both has sense.
Pavel
regards
--
Tomas Vondra http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления: