Skip site navigation (1) Skip section navigation (2)

Creating a case insensitive data type

From: Dave <david(dot)majnemer(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Creating a case insensitive data type
Date: 2006-05-26 00:23:53
Message-ID: 44764A99.8030606@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
could CREATE TYPE be used to make a case insensitive version of varchar? 
So that doing something like LOWER(username) = 'joe' could just be done 
like username = 'joe' ?

I want to try to avoid using CREATE TYPE with C extensions and using a 
new operator all over the place is not an option... How could I do this? 
Can I accomplish this via another method?

-Dave

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2006-05-26 00:56:54
Subject: Re: Gborg and pgfoundry
Previous:From: Rodrigo HjortDate: 2006-05-25 23:41:17
Subject: Re: LIKE, leading percent, bind parameters and indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group