Bruce Momjian <[EMAIL PROTECTED]> writes:Anyway,
Uh, the problem with long keywords is that you are then requiring the
_parser_ to identify those keywords, and at that point, the entire text
between the keywords has been sliced up by the lexer, which will
certainly make it a mess. I might be wrong that we can even use more
then two characters for the start of quote string
You're wrong. We can use anything we like for the start of the quote string; flex is quite capable of recognizing fixed strings, and even variable ones. I'd prefer to avoid expecting it to handle up/downcasing, I think, but there is no technical reason that the delimiter couldn't look like a keyword.
My objection to the proposal FUNCTIONBODY is that it makes it look like
the feature is only useful in CREATE FUNCTION. In point of fact, the
quoting facility could be used to construct any SQL string literal. The
comparison points I am thinking about are shell here-documents and
Perl quoting conventions, both of which are used for many things.
a viable solution seems to be very near, the general direction is quite clear.
Problem with pure literal quote strings is that they couldn't be immediately adjacent to literal strings, so they should start end end with special chars:
$QUOTE1$This is my string$ENDQUOTE1$
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org