2014/1/15 Bruce Momjian <br...@momjian.us> > On Wed, Jan 15, 2014 at 04:55:11PM +0100, Pavel Stehule wrote: > > The problem is that these are philosophical issues that are not > normally > > covered in our docs. What I have done is to add a mention of which > > option is compliant to the new text. Patch attached. > > > > Is GET DIAGNOSTICS defined in the standard for SQL/PSM only or for > > generic SQL? > > > > > > > > I found this statement in ANSI SQL 92 - and few minutes searching - it > is in > > generic SQL - today "SQL framework" part and it is enhanced in "SQL/PSM" > > OK, patch updated. >
ok I don't understand last sentence of comment ! /* ! * Ada-based PL/SQL uses := for assignment and variable defaults, while ! * the SQL standard uses equals for these cases and for GET ! * DIAGNOSTICS, so we support both. FOR and OPEN only support :=. ! */ ! assign_operator : '=' "FOR and OPEN only support :=" FOR statement nor OPEN statement doesn't use ":=" Regards Pavel > -- > Bruce Momjian <br...@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + Everyone has their own god. + >
