Andreas Pflug wrote:
> >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.
> >
> >
> Anyway,
> 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$
You mean if the special quotes are <-- and -->, <-----> would be the
same as '-'?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073