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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: So do we really *need* those substring() ops in tab-completion queries?
Date: 2010-01-03 05:41:05
Message-ID: 27794.1262497265@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark <gsstark(at)mit(dot)edu> writes:
> On Sun, Jan 3, 2010 at 1:21 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2010-01-03 07:00:57 Re: about some parameters
Previous Message Hitoshi Harada 2010-01-03 05:21:54 Re: PATCH: Add hstore_to_json()