From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: massive quotes? |
Date: | 2003-09-11 21:03:36 |
Message-ID: | 3F60E328.8030300@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>>Tom Lane wrote:
>>
>>
>>>I believe we could make
>>>it a good deal more robust if both the opening and closing markers
>>>(whatever they are) are required to stand alone on a line.
>>>
>>>
>>>
>>Hard to detect whitespace might trip things up. I wish I had a $ for
>>every time that has made my life difficult.
>>
>>
>
>I could accept a definition that allowed trailing whitespace on the same
>line as the marker, but not any other visible characters.
>
>
This contradicts a wish you made earlier, using this extended quoting
for further reducing quote-quoting. IMHO, such a single-line quote
marker would be totally sufficient, it would reduce '''''''' to '''',
and if you write \'\' (what I prefer) it gets even more distinguishable
(actually, this is the way pgAdmin3's function wizard works).
But if we're back to a single line, it's somehow like a keyword,
separated by space-chars. FUNCTIONBODY might be a bit function-centric,
so how about QUOTE and ENDQUOTE? In case another quote level makes
sense, it could be QUOTE(1) and ENDQUOTE(1), or only a pair of QUOTE(n).
Anyway, I think such a here-documents or single line quote marker
solution would be a great enhancement, details are now merely a question
of taste.
While this sounds "nearly done" for me, as there seems some fundamental
consense, I'll will probably have to wait for 7.5?
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-11 21:11:12 | Re: Another small bug (pg_autovacuum) |
Previous Message | Jan Wieck | 2003-09-11 20:46:42 | Re: massive quotes? |