From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Updated CREATE FUNCTION syntax |
Date: | 2002-05-16 17:21:32 |
Message-ID: | Pine.LNX.4.44.0205161748260.1096-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
As per earlier vague hint, I'm bringing the CREATE FUNCTION syntax in line
with SQL99. Everything is fully backward compatible. Here is the new
synopsis:
CREATE [OR REPLACE] FUNCTION name (args) RETURNS type
option [ option... ] [WITH (...)];
where option is any of these in any order:
AS string [,string]
LANGUAGE name
IMMUTABLE
STABLE
VOLATILE
CALLED ON NULL INPUT -- SQL spelling of not "strict"
RETURNS NULL ON NULL INPUT -- SQL spelling of "strict"
STRICT
[EXTERNAL] SECURITY DEFINER -- SQL spelling of "setuid"
[EXTERNAL] SECURITY INVOKER -- SQL spelling of not "setuid"
IMPLICIT CAST
(The SECURITY options are noops right now, but I'm planning to implement
them next.)
The WITH (...) options are still there, but sort of less encouraged, I
guess.
--
Peter Eisentraut peter_e(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-05-16 17:21:56 | Re: Kerberos principal to dbuser mapping |
Previous Message | Bear Giles | 2002-05-16 15:09:11 | Re: Kerberos principal to dbuser mapping |