Re: pl/pgsql: END verbosity - Mailing list pgsql-hackers

From Neil Conway
Subject Re: pl/pgsql: END verbosity
Date
Msg-id 42BEC8C6.8020407@samurai.com
Whole thread Raw
In response to Re: pl/pgsql: END verbosity  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: pl/pgsql: END verbosity
Re: pl/pgsql: END verbosity
List pgsql-hackers
Peter Eisentraut wrote:
> It is required by the SQL standard.

No, it isn't -- PL/PgSQL is not defined by the SQL standard. I guess 
you're referring to SQL/PSM, but that has only a passing resemblance to 
PL/PgSQL. Implementing SQL/PSM in some form would definitely be worth 
doing (especially now that MySQL have), but I haven't seen any plans to 
do that by adapting PL/PgSQL to SQL/PSM.

In any case, there are plenty of cases in which we accept a superset of 
the syntax defined by the SQL standard -- DROP TABLE { RESTRICT | 
CASCADE }, for example. We have never interpreted compliance with the 
SQL specification to mean that we must *only* accept the standard's 
syntax and nothing else.

-Neil


pgsql-hackers by date:

Previous
From: Atsushi Ogawa
Date:
Subject: Re: [PATCHES] regexp_replace
Next
From: Peter Eisentraut
Date:
Subject: Re: pl/pgsql: END verbosity