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