On Fri, Mar 20, 2015 at 06:53:29PM -0700, David G. Johnston wrote: > On Friday, March 20, 2015, Bruce Momjian <br...@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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
