pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>
>
>




view thread (3+ messages)

Message-ID: <012e01bfe527$61736160$0300000a@doot.org>
Permalink:  ../012e01bfe527$61736160$0300000a@doot.org/
Also on:    postgresql.org/message-id/012e01bfe527$61736160$0300000a@doot.org

 · 

reply

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