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.
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 |