Re: proposal: doc: simplify examples of dynamic SQL

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: proposal: doc: simplify examples of dynamic SQL
Дата
Msg-id
20150321014718.GB13192@momjian.us
Ответ на
Список
Дерево обсуждения
proposal: doc: simplify examples of dynamic SQL Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: proposal: doc: simplify examples of dynamic SQL David G Johnston <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL Alvaro Herrera <alvherre@2ndquadrant.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL Alvaro Herrera <alvherre@2ndquadrant.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL "David G. Johnston" <david.g.johnston@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Bruce Momjian <bruce@momjian.us>
Re: proposal: doc: simplify examples of dynamic SQL Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: proposal: doc: simplify examples of dynamic SQL Pavel Stehule <pavel.stehule@gmail.com>
Re: proposal: doc: simplify examples of dynamic SQL Pavel Stehule <pavel.stehule@gmail.com>
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.

-- 
  Bruce Momjian          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +
В списке pgsql-hackers по дате отправления
От: Tomas Vondra
Дата:
От: David G. Johnston
Дата:
FAQ