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
|
Список | 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 по дате отправления: