From: Mitch Vincent <mitch@venux.net>
To: Joern Muehlencord <jomu@uni-paderborn.de>
To: gpsql-sql <pgsql-sql@postgresql.org>
Subject: Re: case insensitive search
Date: Mon, 3 Jul 2000 15:46:27 -0400
Message-ID: <012e01bfe527$61736160$0300000a@doot.org> (raw)
References: <12843.000626@uni-paderborn.de>
SELECT whatever FROM wherever WHERE lower(yourfield) = 'this';
You can do it with a case inseneitive regex search but they can't use
indexes and can become very slow on large tables..
SELECT whatever FROM wherever WHERE yourfield ~* 'this';
lower() does leak a bit of memory from what I've heard on the list but I'm
sure someone is working on it..
-Mitch
----- Original Message -----
From: Joern Muehlencord <jomu@uni-paderborn.de>
To: gpsql-sql <pgsql-sql@postgresql.org>
Sent: Monday, June 26, 2000 2:14 PM
Subject: [SQL] case insensitive search
> Hello together,
>
> how can I handle case insensitive search in a table?
>
>
>
> --
> Linux is like wigwam - no windows, no gates, apache inside.
> In diesem Sinne
> Joern
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mitch@venux.net, jomu@uni-paderborn.de
Subject: Re: case insensitive search
In-Reply-To: <012e01bfe527$61736160$0300000a@doot.org>
References: <12843.000626@uni-paderborn.de> <012e01bfe527$61736160$0300000a@doot.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox