Postgres Pro
Downloads
Home   >   mailing lists

case insensitive sorting & searching in oracle 10g - Mailing list pgsql-general

From David Garamond
Subject case insensitive sorting & searching in oracle 10g
Date
Msg-id 4111F814.3020504@zara.6.isreserved.com
Whole thread Raw
Responses Re: case insensitive sorting & searching in oracle 10g  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Re: case insensitive sorting & searching in oracle 10g  (Tommi Maekitalo <t.maekitalo@epgmbh.de>)
Re: case insensitive sorting & searching in oracle 10g  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Tree view 
in oracle 10g, you can issue:

  ALTER SESSION SET NLS_COMP = ansi;
  ALTER SESSION SET NLS_SORT = binary_ci;

do you think this is an elegant solution for case insensitive sorting &
searching? is there interest in seeing this in postgres?

--
dave

pgsql-general by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: Recursive PLPGSQL function?
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: case insensitive sorting & searching in oracle 10g