From: Marc Mamin <M.Mamin@intershop.de>
To: "'pgsql-docs@postgresql.org'" <pgsql-docs@postgresql.org>
Subject: misleading lang_name case in CREATE FUNCTION doc.
Thread-Topic: misleading lang_name case in CREATE FUNCTION doc.
Thread-Index: Ac7GXS61bD3RutitRBOd1grc/Xx15w==
Date: Fri, 11 Oct 2013 08:37:55 +0000
Message-ID: 
 <B6F6FD62F2624C4C9916AC0175D56D880CE2A93C@jenmbs01.ad.intershop.net>
Accept-Language: de-DE, en-US
Content-Language: en-US
Content-Type: multipart/alternative;
 boundary="_000_B6F6FD62F2624C4C9916AC0175D56D880CE2A93Cjenmbs01adinter_"
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--_000_B6F6FD62F2624C4C9916AC0175D56D880CE2A93Cjenmbs01adinter_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,
you might want to lowercase the language names in order to be compatible wi=
th the case restriction introduced in  9.2.
or add a sentence like
'when using single quotes, the names  are case sensitive (with is lowercase=
 for most (all?) languages).

regards,

Marc Mamin


http://www.postgresql.org/docs/9.3/static/sql-createfunction.html

lang_name

    The name of the language that the function is implemented in.
    Can be SQL, C, internal, or the name of a user-defined procedural langu=
age.
    For backward compatibility, the name can be enclosed by single quotes.


http://www.postgresql.org/docs/current/static/release-9-2.html

No longer forcibly lowercase procedural language names in CREATE FUNCTION (=
Robert Haas)

While unquoted language identifiers are still lowercased,
strings and quoted identifiers are no longer forcibly down-cased.
Thus for example CREATE FUNCTION ... LANGUAGE 'C' will no longer work;
it must be spelled 'c', or better omit the quotes.


--_000_B6F6FD62F2624C4C9916AC0175D56D880CE2A93Cjenmbs01adinter_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left:=
 #800000 2px solid; } --></style>
</head>
<body>
<font face=3D"Calibri" size=3D"2"><span style=3D"font-size:11pt;">
<div>Hi,</div>
<div>you might want to lowercase the language names in order to be compatib=
le with the case restriction introduced in&nbsp; 9.2.</div>
<div>or add a sentence like</div>
<div>'when using single quotes, the names&nbsp; are case sensitive (with is=
 lowercase for most (all?) languages).</div>
<div>&nbsp;</div>
<div>regards,</div>
<div>&nbsp;</div>
<div>Marc Mamin</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><a href=3D"http://www.postgresql.org/docs/9.3/static/sql-createfunctio=
n.html"><font color=3D"blue"><u>http://www.postgresql.org/docs/9.3/static/s=
ql-createfunction.html</u></font></a> </div>
<div>&nbsp;</div>
<div>lang_name</div>
<div>&nbsp;</div>
<div>&nbsp;&nbsp;&nbsp; The name of the language that the function is imple=
mented in. </div>
<div>&nbsp;&nbsp;&nbsp; Can be SQL, C, internal, or the name of a user-defi=
ned procedural language. </div>
<div>&nbsp;&nbsp;&nbsp; For backward compatibility, the name can be enclose=
d by single quotes.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><a href=3D"http://www.postgresql.org/docs/current/static/release-9-2.h=
tml"><font color=3D"blue"><u>http://www.postgresql.org/docs/current/static/=
release-9-2.html</u></font></a> </div>
<div>&nbsp;</div>
<div>No longer forcibly lowercase procedural language names in CREATE FUNCT=
ION (Robert Haas)</div>
<div>&nbsp;</div>
<div>While unquoted language identifiers are still lowercased, </div>
<div>strings and quoted identifiers are no longer forcibly down-cased. </di=
v>
<div>Thus for example CREATE FUNCTION ... LANGUAGE 'C' will no longer work;=
 </div>
<div>it must be spelled 'c', or better omit the quotes.</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
</span></font>
</body>
</html>

--_000_B6F6FD62F2624C4C9916AC0175D56D880CE2A93Cjenmbs01adinter_--