Re: So do we really *need* those substring() ops in tab-completion queries? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: So do we really *need* those substring() ops in tab-completion queries?
Date
Msg-id 27794.1262497265@sss.pgh.pa.us
Whole thread Raw
In response to Re: So do we really *need* those substring() ops in tab-completion queries?  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> On Sun, Jan 3, 2010 at 1:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> �If the conditions
>> were phrased in a way that made them indexable, they might be worth the
>> trouble --- but they aren't.

> Wow, that is weird, especially since it's *easier* to write them
> properly using LIKE anyways.

Really?  You'd have to worry about escaping _ and % ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: PATCH: Add hstore_to_json()
Next
From: Jaime Casanova
Date:
Subject: Re: about some parameters