misleading lang_name case in CREATE FUNCTION doc.

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "'pgsql-docs(at)postgresql(dot)org'" <pgsql-docs(at)postgresql(dot)org>
Subject: misleading lang_name case in CREATE FUNCTION doc.
Date: 2013-10-11 08:37:55
Message-ID: B6F6FD62F2624C4C9916AC0175D56D880CE2A93C@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message liuyuanyuan@highgo.com.cn 2013-11-01 05:21:44 seek advice about translation management
Previous Message rudolf 2013-09-20 08:05:02 Re: "format" function documentation fix