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

Data Search

From: Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Data Search
Date: 1999-12-29 15:06:33
Message-ID: 3.0.6.32.19991229090633.0097a4a0@y2k.state.il.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Howdy,

I'm try to do a search on users from one database against a table in another.

Both databases have a mixture of upper and lowercase characters. Is there a
way to tell postgres to consider a match if the absolute character is the
same regardless of case?

Ex 
'ROB' should also produce a hit if postgres encouters 'rob'

Thanks,

-Rob


Responses

pgsql-interfaces by date

Next:From: Ed LoehrDate: 1999-12-29 16:02:15
Subject: Re: [INTERFACES] Data Search
Previous:From: Michael MeskesDate: 1999-12-29 12:34:01
Subject: Re: [INTERFACES] manipulate array wiht ecpg

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