Re: ILIKE
Justin Clift <justin@postgresql.org>
From: Justin Clift <justin@postgresql.org>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org
Date: 2003-02-24T14:39:20Z
Lists: pgsql-hackers
Peter Eisentraut wrote: > Tom Lane writes: > >>My feeling too. Whatever you may think of its usefulness, it's been a >>documented feature since 7.1. It's a bit late to reconsider. > > It's never too late for new users to reconsider. It's also never too late > to change your application of performance is not satisfactory. > Well, ILIKE has been a feature for quite some time and the amount of negative feedback we've been receiving about upgrade problems makes me feel that _removing_ it would be detrimental. (i.e. broken applications) As an alternative to _removing_ it, would a feasible idea be to transparently alias it to something else, say a specific type of regex query or something? Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi