Andreas said
>>
Well we might also have something like
CREATE FUNCTION ... AS QUOTE('MyEndMarker')
....
all the stuff
... MyEndMarker LANGUAGE 'plpgsql';
This looks quite SQL-like and should be easily implementable. Anyway,
this Perl-like style or Tom's proof-of-concept dollar-quoting one, both
seem equally usable, now let's have someone roll a die to decide.
>>
But if THIS solution is implemented then
QUOTE('MyEndMarker')
and
MyEndMarker
become noise words and it seems the parser could just assume to handle everything between
CREATE FUNCTION ... AS
and
LANGUAGE
as the delimiters for a function definition.
But as that's so simple I must be missing something.
Rick