Re: LIKE/ESCAPE implementation

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Thomas Swan <tswan(at)olemiss(dot)edu>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LIKE/ESCAPE implementation
Date: 2000-08-05 06:59:42
Message-ID: 398BBB5E.DE8F9AC6@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Would their be anything like an ILIKE for a case insensitive like
> search? Or maybe insensitive over text/char/varchar datatypes?

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?

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-08-05 07:07:46 COALESCE implementation question
Previous Message Thomas Swan 2000-08-05 06:26:00 Re: LIKE/ESCAPE implementation