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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend