Re: Dollar quoting docs, round 1

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Dollar quoting docs, round 1
Date: 2004-04-28 16:52:34
Message-ID: 408FE152.5040706@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Bruce Momjian wrote:

>David Fetter wrote:
>
>
>>On Wed, Apr 28, 2004 at 08:28:58AM +0200, Peter Eisentraut wrote:
>>
>>
>>>David Fetter wrote:
>>>
>>>
>>>>Kind people,
>>>>
>>>>Please find attached a diff to the SGML docs that attempts to go
>>>>over the new dollar quoting feature.
>>>>
>>>>
>>>I think we should just use $$ in each case. Otherwise it might look
>>>more complicated than before.
>>>
>>>
>>Peter,
>>
>>I'd be delighted to simplify some of the quotes. They can't all be $$
>>because of the nesting, so that's out. Also, I believe it is a good
>>idea to give some idea of what is going on with the tags, as I do with
>>similar structures in other languages. For example, when I am writing
>>up a piece of SQL in perl or php, the tag looks like this:
>>
>>$sql = <<SQL
>>...
>>SQL
>>
>>$sql = <<<SQL
>>...
>>SQL;
>>
>>
>
>Interesting, but I think most people like to use a tag that identifies
>what is happening, rather than the content. I think that's why <<END is
>used frequently, so END appears as the end. Seeing SQL alone on a line
>seems strange.
>
>
>

I typically combine these approaches, with a heredoc marker like EOSQL

cheers

andrew

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message David Fetter 2004-04-28 16:53:56 Re: Dollar quoting docs, round 1
Previous Message Bruce Momjian 2004-04-28 16:32:33 Re: Dollar quoting docs, round 1