At 03:43 PM 12/11/2000 +, [EMAIL PROTECTED] wrote:
>As an aside in DB2 there is the concept of a shared weight index which
>depending
>on
>locale lumps lower/upper case characters together so that you don't have to
>include
>an UPPER in the SQL - and it will use the index. Perhaps postgres c
Tomas Berndtsson <[EMAIL PROTECTED]> writes:
> Related to this, is there any way to make an index for a table
> case-insensitive? If you have an index, but use upper() in the select,
> the index is not used.
Sure, make a functional index:
play=> create table foo (f1 text);
CREATE
play=> create i
"Hancock, David (DHANCOCK)" <[EMAIL PROTECTED]> writes:
> Abe: It's an SQL thing or a scripting thing. It's probably easiest and
> safest in the SQL:
>
>select firstname, surname from employees
> where upper(firstname) like upper('%$criteria%') or
> upper(surname) like upper('%$
On Sunday 10 December 2000 07:23, Abe wrote:
> This is probably an easy question for most but here goes:
>
> I am using PHP3 and postgres 6.5
>
> I am trying to do a search on a peoples database and it works fine except
> for the fact that I want to make it case insensitive as some in the
> databa
olumn and the search string to uppercase befor
comparing, and it won't matter how it's stored in the database.
Cheers!
--
David Hancock
-Original Message-
From: Abe
To: [EMAIL PROTECTED]
Sent: 12/10/00 7:23 AM
Subject: [GENERAL] Simple Question: Case sensitivity
This is probably an
Thanks David,
works a treat!
Abe
- Original Message -
From: "Hancock, David (DHANCOCK)" <[EMAIL PROTECTED]>
To: "'Abe '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, December 10, 2000 12:48 PM
Subject: RE: [GENERAL] Simple Quest
This is probably an easy question for most but here goes:
I am using PHP3 and postgres 6.5
I am trying to do a search on a peoples database and it works fine except
for the fact that I want to make it case insensitive as some in the database
are Smith and some are jones. Is this a scripting thi
