Re: Case-Insensitve Text Comparison
From:
Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To:
"David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc:
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Case-Insensitve Text Comparison
Date:
2008-06-02 04:13:58
Message-ID:
48437386.5080604@sun.com (view raw or flat )
Thread:
2008-06-02 03:53:25 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 04:08:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-06-02 05:13:07 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 05:18:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-06-02 05:36:48 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 13:51:39 from Andrew Sullivan <ajs(at)commandprompt(dot)com>
2008-06-02 15:39:53 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 17:29:30 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-06-02 17:55:16 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2008-06-02 18:08:55 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-06-02 21:28:18 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2008-06-03 09:27:29 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-06-03 16:36:45 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-03 19:06:48 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-06-03 19:18:48 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-03 19:26:06 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-06-03 20:53:56 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-06-04 04:06:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-06-04 04:35:40 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2008-06-05 16:38:07 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-06-03 19:45:12 from "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
2008-06-03 20:18:32 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-06-02 19:50:32 from Shane Ambler <pgsql(at)Sheeky(dot)Biz>
2008-06-02 18:24:12 from Andrew Sullivan <ajs(at)commandprompt(dot)com>
2008-06-02 18:38:30 from Tino Wildenhain <tino(at)wildenhain(dot)de>
2008-06-02 17:56:32 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-06-02 16:13:55 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 16:33:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-06-02 16:45:27 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 04:13:58 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2008-06-02 05:21:47 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2008-06-02 05:37:26 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2008-06-02 05:48:36 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Lists:
pgsql-hackers
David E. Wheeler napsal(a):
> Howdy,
>
> I'm sure I'm just showing off my ignorance here, but here goes…
>
> I really need case-insensitive string comparison in my database.
Collation per database level should be help you. It is now under development and
I hope it will be part of 8.4. You can see
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00857.php
Zdenek
In response to
pgsql-hackers by date
Next :From: Joshua D. DrakeDate: 2008-06-02 04:46:20Subject : Re: Overhauling GUCSPrevious :From : Tom LaneDate : 2008-06-02 04:08:35Subject : Re: Case-Insensitve Text Comparison
