Re: proposal: doc: simplify examples of dynamic SQL

On Fri, Mar 20, 2015 at 06:53:29PM -0700, David G. Johnston wrote:
> 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

True, but that just looks odd.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +