Re: massive quotes?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: massive quotes?
Date: 2003-09-11 22:33:58
Message-ID: 3F60F856.104@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

>Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>
>
>>So you are requiring the identical text to appear at the beginning and
>>end of the quote, rather than a here document that would be:
>>
>>
>
>
>
>> <<END
>> ...
>> END
>>
>>
>
>
>
>>or in your example:
>>
>>
>
>
>
>> $$END
>> ...
>> END
>>
>>
>
>Yes, I was thinking of requiring the $$ to appear at both beginning and
>end. This is perhaps not critical, but it seems more symmetric that
>way. Also, we might even be able to get away with allowing SQL text to
>resume on the same line as the terminator, for example
>
> CREATE FUNCTION foo() RETURNS int AS $$FUNCTION
> ... text here ...
> $$FUNCTION LANGUAGE plpgsql;
>
>I would not want to risk that with a plain word as terminator, but $$
>helps a lot to make it distinctive.
>
>

This discussion now seems to be on the right track - thanks for
recognising a need, meeting which will clearly improve the useability of
the product.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2003-09-11 22:50:35 Re: Another small bug (pg_autovacuum)
Previous Message Gaetano Mendola 2003-09-11 22:28:21 Re: Problem with function permission test in a view