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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: Tim Allen <tim(at)proximity(dot)com(dot)au>, Thomas Hallgren <thomas(at)tada(dot)se>, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Worthwhile optimisation of position()?
- Date: Fri, 24 Mar 2006 14:58:54 +0800
- Message-id: <442398AE(dot)9000409(at)calorieking(dot)com>
Yeah. AFAICS the transformation Chris suggested is valid. I'm really dubious that it's worth expending planner cycles to look for it though. LIKE is something that everybody and his brother uses, but who uses this position()=0 locution?
One of our junior developers :) Which is why I noticed it. Chris
- Follow-Ups:
- Re: Worthwhile optimisation of position()?
- From: Jim C. Nasby
- Re: Worthwhile optimisation of position()?
- 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
- Worthwhile optimisation of position()?
- Prev by Date: Re: Worthwhile optimisation of position()?
- Next by Date: Re: Worthwhile optimisation of position()?
- Previous by thread: Re: Worthwhile optimisation of position()?
- Next by thread: Re: Worthwhile optimisation of position()?
- Indexes: