Case insensitive equality operator - Mailing list pgsql-sql

From Christophe Labouisse
Subject Case insensitive equality operator
Date
Msg-id m3g19miutu.fsf@gabuzo.meunet
Whole thread Raw
List pgsql-sql
I'm looking for a case insensitive equality operator (something like
~~*). There are of course regular expression matches but I am
reluctent to use them because I need to preprocess my string before
using it (putting it between a ^ and a $, escaping special characters)
and because I'm afraid that the use of regular expressions will be
more resource demanding than a simple equality.

Any ideas ?

Cheers

Christophe Labouisse : Cinéma, typographie, Unix
labouiss@club-internet.fr http://gabuzo.home.ml.org/
Le cinéma en Lumière : http://www.lumiere.org/

pgsql-sql by date:

Previous
From: Kim Markle
Date:
Subject: Postgres functions and Stored Procedures?
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Case insensitive equality operator