Re: proposal: doc: simplify examples of dynamic SQL
От | David G. Johnston |
---|---|
Тема | Re: proposal: doc: simplify examples of dynamic SQL |
Дата | |
Msg-id | CAKFQuwa+_TKmAmNZATs34n95SO+=XfQus41nR7Z7V5AkHto4Cg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: proposal: doc: simplify examples of dynamic SQL (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: proposal: doc: simplify examples of dynamic SQL
|
Список | pgsql-hackers |
On Friday, March 20, 2015, Bruce Momjian <bruce@momjian.us> wrote:
On Fri, Mar 20, 2015 at 05:50:03PM -0700, David G. Johnston wrote:
> I'm not sure that this particular feature of the standard is something we
> should encourage.
>
> Its actually quite useful in this situation, and so maybe the novelty is just
> making me nervous, but the only reason I know of this behavior is because I've
> seen a number of posts in just the past couple of years when people
> accidentally used this feature and then were surprised when they didn't get an
> error. If this stays I would suggest that we take the opportunity to
> cross-reference back to where the syntax is defined so people aren't left
> scratching their heads as to why it works - or why if they remove the newline
> in their own attempt the code suddenly breaks.
Yeah, I am kind on the fence about it, but it is a nice feature,
particulary for PL/pgSQL programs. I added a mention of the string
concatentation feature --- patch attached, and URL updated.
The third option is to just embed a new line in the string itself.
Execute Format(’...
...', tbl)
USING val
David J.
В списке pgsql-hackers по дате отправления: