| From: | Jeff Davis <pgsql(at)j-davis(dot)com> | 
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> | 
| Cc: | David Fetter <david(at)fetter(dot)org>, Mike Fowler <mike(at)mlfowler(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Round Robin Reviewers <pgsql-rrreviewers(at)postgresql(dot)org> | 
| Subject: | Re: Review: Re: [PATCH] Re: [HACKERS] Adding xpath_exists function | 
| Date: | 2010-07-27 23:55:52 | 
| Message-ID: | 1280274952.11610.7.camel@jdavis-ux.asterdata.local | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers pgsql-rrreviewers | 
On Tue, 2010-07-27 at 19:41 -0400, Robert Haas wrote:
> On Tue, Jul 27, 2010 at 7:33 PM, David Fetter <david(at)fetter(dot)org> wrote:
> >        Minor quibble with the regression tests: should we be using
> >        dollar quotes in things like this?  Doubled-up quote marks:
> >
> >        SELECT xpath_exists('//town[text() = ''Cwmbran'']','<towns><town>Bidford-on-Avon</town><town>Cwmbran</town><town>Bristol</town></towns>'::xml);
> >
> >        Dollar quote:
> >
> >        SELECT xpath_exists($$//town[text() = 'Cwmbran']$$,'<towns><town>Bidford-on-Avon</town><town>Cwmbran</town><town>Bristol</town></towns>'::xml);
> 
> Personally, I don't really see that as an improvement.  Dollar-quotes
> are really nice for longer strings, or where you would otherwise have
> quadrupled quotes (or more), but I don't see a big advantage to it
> here.  Still, it's a question of opinion more than anything else.
I like the idea of using dollar quotes, but I think they should be used
for both arguments (or neither). Using $$ for one and then shifting to
"'" for the second argument with no whitespace at all seems like the
least readable option.
Regards,
	Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-07-28 00:27:48 | Re: Incorrect FTS result with GIN index | 
| Previous Message | Tom Lane | 2010-07-27 23:47:20 | Re: Parsing of aggregate ORDER BY clauses | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-07-28 13:58:43 | Another patch now needs reviewer | 
| Previous Message | Robert Haas | 2010-07-27 23:41:29 | Re: Review: Re: [PATCH] Re: [HACKERS] Adding xpath_exists function |