From: | "Ben Schneider" <bcschnei(at)attbi(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org>, <pgsql-php(at)postgresql(dot)org> |
Subject: | Case Insensitive Searching? |
Date: | 2003-05-23 20:24:36 |
Message-ID: | 001301c32169$54d90fa0$5011a8c0@micronpc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-php |
I am working on a project where I am creating a PHP front end to a Postgres
database. The schema is new but the data is old. Meaning I had to convert
the data from the old Informix DB.
Anyway all of the existing data is in all upper case. However new data going
in will be in both upper and lower case.(As requested by the customer.)
So the question is, how do I perform a case insensitive search? Is there a
DB setting I can set to ignore the case?
If not, then an example of some PHP code that can do this would be of a
great help.
Thanks,
Ben
From | Date | Subject | |
---|---|---|---|
Next Message | papapep | 2003-05-24 09:38:54 | Re: Inserting data of two other tables |
Previous Message | Tom Lane | 2003-05-23 19:31:40 | Re: Inserting data of two other tables |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-05-24 09:03:17 | Re: Number of connections |
Previous Message | scott.marlowe | 2003-05-23 17:53:56 | Re: faster output from php and postgres |