Andrew Gierth wrote:
> >>>>> "Andreas" == Andreas Karlsson <andr...@proxel.se> writes:
>
> Andreas> It would be a pain if the SQL committee started using MAP for
> Andreas> something.
>
> They already did - MAP is a non-reserved keyword in sql2016, used at
> least with <user-defined ordering definition>. Can't see any obvious
> conflict with use in expressions, but I haven't checked all the
> references.
Ah, so in SQL2011 (and 2016) there already is a designator for routines,
which was a thing we were lacking previously, as I recall.
<specific routine designator> ::=
SPECIFIC <routine type> <specific name>
| <routine type> <member name> [ FOR <schema-resolved user-defined type
name> ]
<routine type> ::=
ROUTINE
| FUNCTION
| PROCEDURE
| [ INSTANCE | STATIC | CONSTRUCTOR ] METHOD
<member name> ::=
<member name alternatives> [ <data type list> ]
<member name alternatives> ::=
<schema qualified routine name>
| <method name>
<data type list> ::= <left paren> [ <data type> [ { <comma> <data type> }... ]
] <right paren>
[elsewhere]
<specific name> ::=
<schema qualified name>
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
