Re: LIKE/ESCAPE implementation
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: Thomas Swan <tswan@olemiss.edu>, Hackers List <pgsql-hackers@postgresql.org>
Date: 2000-08-06T02:37:10Z
Lists: pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> What is ILIKE? afaik it is not in SQL9x, so is there any reason to have
> that rather than the full regular expression case-insensitive operator
> ("~*") we already have?
Just that a lot of people have asked for it, over and over again ...
see the archives ...
regards, tom lane