[GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-24 Thread Timothy Madden
already present in PostgreSQL (binary objects, SQL functions), some effort to also make the syntax conforming to the standards should be worthy ... Thank you, Timothy Madden

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
On Sat, Oct 24, 2009 at 5:41 PM, Tom Lane wrote: > Timothy Madden writes: > > Can the string literal syntax for the function body in a CREATE FUNCTION > > statement please, > > please be dropped ? > > No. Since the function's language might be anything, there&#

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
On Sun, Oct 25, 2009 at 8:49 PM, Adrian Klaver wrote: > On Sunday 25 October 2009 9:17:04 am Timothy Madden wrote: > > On Sat, Oct 24, 2009 at 5:41 PM, Tom Lane wrote: > > > Timothy Madden writes: > > > > Can the string literal syntax for the function bod

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
llow, with the LANGUAGE declaration after (default behavior). I am interested in the functions I write by hand as an application developer; pg_dump may dump the functions any way it finds suitable (although I would still prefer the conforming form). Thank you, Timothy Madden

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
On Sun, Oct 25, 2009 at 11:33 PM, Scott Marlowe wrote: > On Sun, Oct 25, 2009 at 2:43 PM, Timothy Madden > wrote: > > Just like when I write C++ applications I use standards-conforming C++, > when > > I write SQL > > applications I would like to use standard-conform

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
On Sun, Oct 25, 2009 at 11:40 PM, Alvaro Herrera 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&#

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
On Mon, Oct 26, 2009 at 12:01 AM, Tom Lane wrote: > Timothy Madden writes: > > What I want is compatible with existing code and the current default > > behavior. Just look for a LANGUAGE SQL declaration in the function > > header (before the body). > > > If found

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread Timothy Madden
On Mon, Oct 26, 2009 at 12:42 AM, Alvaro Herrera wrote: > Timothy Madden escribió: > > > Anyway Posgres offers a CREATE FUNCTION statement that resembles or > should > > resemble that in the standard, and that is what I am talking about. > > "Should" bein

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-26 Thread Timothy Madden
m what I know, especially that the effort to understand the project is comprehensive. That is why I was concerned about agreement. The DELIMITER artefact is also misplaced in my opinion; what is the use for it ? The BEGIN ... END syntax is pretty clear ... DELIMITER is just to keep the client-side parsing / input simple ? For other languages the string literal syntax is ok, my issue only concerns LANGUAGE SQL functions Thank you, Timothy Madden