Postgres Pro
Downloads
Home   >   mailing lists

Re: Worthwhile optimisation of position()? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Worthwhile optimisation of position()?
Date
Msg-id 4423A0B1.1010107@calorieking.com
Whole thread Raw
In response to Re: Worthwhile optimisation of position()?  (Thomas Hallgren <thomas@tada.se>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgNixInstaller: Making PostgreSQL relocatable
Next
From: Dave Page
Date:
Subject: Re: Did this work in earlier version of Postgres?