Re: massive quotes? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: massive quotes?
Date
Msg-id 200309111707.h8BH7sP19988@candle.pha.pa.us
Whole thread Raw
In response to Re: massive quotes?  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: massive quotes?  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: massive quotes?
Next
From: Bruce Momjian
Date:
Subject: Re: Problem with function permission test in a view