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
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 |