Re: Worthwhile optimisation of position()?

From: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
To: Thomas Hallgren <thomas(at)tada(dot)se>
Cc: Tim Allen <tim(at)proximity(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Worthwhile optimisation of position()?
Date: 2006-03-24 07:33:05
Message-ID: 4423A0B1.1010107@calorieking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> The docs are correct so my initial point was correct. "position('ch' in
> user) = 0" is equivalent to "user NOT LIKE '%ch%'" and there's no way
> you can index that.

Well = 1 then.

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2006-03-24 09:03:04 Re: Did this work in earlier version of Postgres?
Previous Message Peter Eisentraut 2006-03-24 07:23:02 Re: pgNixInstaller: Making PostgreSQL relocatable