Re: Can the string literal syntax for function definitions please be dropped ? - Mailing list pgsql-general

From Timothy Madden
Subject Re: Can the string literal syntax for function definitions please be dropped ?
Date
Msg-id 5078d8af0910251512i53dc1c4cnf290fd07496b8dc@mail.gmail.com
Whole thread Raw
In response to Re: Can the string literal syntax for function definitions please be dropped ?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Can the string literal syntax for function definitions please be dropped ?
List pgsql-general


On Sun, Oct 25, 2009 at 11:40 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote:
Timothy Madden escribió:

> Just like when I write C++ applications I use standards-conforming
> C++, when I write SQL applications I would like to use
> standard-conforming SQL.

Sadly, we don't have standards-conformant SQL/PSM.  Right now, we have a
lot of different languages for functions, none of them mandated by SQL,
and there is no reason to create a syntax exception for any of them.

I am sure that when we get SQL/PSM support, the interest in getting
standards-conformant procedure creation statements is going to get a lot
higher.

PL/pgSQL is not SQL/PSM.


Anyway Posgres offers a CREATE FUNCTION statement that resembles or should
resemble that in the standard, and that is what I am talking about. I just want the
Postgres version of the statement to look more like the standard one.

Would you detail the differences you talk about that you see here ?

Thank you,
Timothy Madden

pgsql-general by date:

Previous
From: Timothy Madden
Date:
Subject: Re: Can the string literal syntax for function definitions please be dropped ?
Next
From: Timothy Madden
Date:
Subject: Re: Can the string literal syntax for function definitions please be dropped ?