public inbox for [email protected]  
help / color / mirror / Atom feed
From: Marc Mamin <[email protected]>
To: '[email protected]' <[email protected]>
Subject: misleading lang_name case in CREATE FUNCTION doc.
Date: Fri, 11 Oct 2013 08:37:55 +0000
Message-ID: <B6F6FD62F2624C4C9916AC0175D56D880CE2A93C@jenmbs01.ad.intershop.net> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

Hi,
you might want to lowercase the language names in order to be compatible with 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 language.
    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.





view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: misleading lang_name case in CREATE FUNCTION doc.
  In-Reply-To: <B6F6FD62F2624C4C9916AC0175D56D880CE2A93C@jenmbs01.ad.intershop.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox