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 442398AE.9000409@calorieking.com
Whole thread Raw
In response to Re: Worthwhile optimisation of position()?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Worthwhile optimisation of position()?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Worthwhile optimisation of position()?
Next
From: Thomas Hallgren
Date:
Subject: Re: Worthwhile optimisation of position()?