Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Worthwhile optimisation of position()?
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 04:01:45 -0600
- Message-id: <20060324100145(dot)GM90527(at)pervasive(dot)com>
On Fri, Mar 24, 2006 at 02:58:54PM +0800, Christopher Kings-Lynne wrote: > >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. Sounds like time to bust out the cluebat. :) -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- 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: Christopher Kings-Lynne
- Worthwhile optimisation of position()?
- Prev by Date: Re: Did this work in earlier version of Postgres?
- Next by Date: Shared memory
- Previous by thread: Re: Worthwhile optimisation of position()?
- Next by thread: Shared memory
- Indexes: