Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 24 Mar 2006 15:33:05 +0800
- Message-id: <4423A0B1(dot)1010107(at)calorieking(dot)com>
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
- References:
- Worthwhile optimisation of position()?
- From: Christopher Kings-Lynne
- Re: Worthwhile optimisation of position()?
- From: Thomas Hallgren
- Re: Worthwhile optimisation of position()?
- From: Tim Allen
- Re: Worthwhile optimisation of position()?
- From: Tom Lane
- Re: Worthwhile optimisation of position()?
- From: Thomas Hallgren
- Re: Worthwhile optimisation of position()?
- From: Thomas Hallgren
- Worthwhile optimisation of position()?
- Prev by Date: Re: pgNixInstaller: Making PostgreSQL relocatable
- Next by Date: Re: Did this work in earlier version of Postgres?
- Previous by thread: Re: Worthwhile optimisation of position()?
- Next by thread: Re: Worthwhile optimisation of position()?
- Indexes: