Re: proof concept: do statement parametrization

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: proof concept: do statement parametrization
Дата
Msg-id 20100704162518.GA9606@anarazel.de
обсуждение исходный текст
Ответ на Re: proof concept: do statement parametrization  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: proof concept: do statement parametrization  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On Sun, Jul 04, 2010 at 11:38:47AM -0400, Andrew Dunstan wrote:
>
>
> Pavel Stehule wrote:
> >>BTW, we intentionally didn't put any provision for parameters into DO
> >>originally.  What's changed to alter that decision?
> >>
> >
> >It just concept - nothing more. And my instinct speak so inline code
> >block without external parametrization is useless.
> >
> >
>
> You have said this before, IIRC, but frankly your instinct is just
> wrong. It is no more useless than are parameter-less functions, and
> I use those frequently. I used a DO block for some useful testing
> just the other day.
In my opinion its even *more* useful than parameterless
functions. In many cases you will use DO to write upgrade scripts or
ad-hoc code.
In both cases its not really much of diference whether you write the
parameter inside the function or outside (as a parameter to it) and
escaping is not a critical part anyway.

So maybe I am missing the point of this discussion?

Andres


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: proof concept: do statement parametrization
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proof concept: do statement parametrization