Search Postgresql Archives

Matching against a field case in-sensitive.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Matching against a field case in-sensitive.
From: James Dooley <jamdooley@xxxxxxxxx>
Date: Mon, 2 Mar 2009 15:40:27 +0100

Hi,

Since PostgreSQL is by default case sensitive, I would like to know if it is possible to do a search or somehow set the column in a relation to be case insensitive (on search at least).

I would however like to store it case sensitive so I can display it as it was stored.

Ps. I am not interested in creating another column.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Matching against a field case in-sensitive.
  - From: Reid Thompson
- Re: Matching against a field case in-sensitive.
  - From: Martin Gainty
- Re: Matching against a field case in-sensitive.
  - From: A. Kretschmer
- Re: Matching against a field case in-sensitive.
  - From: Serge Fonville

Prev by Date: Re: Shared Buffers
Next by Date: Re: Matching against a field case in-sensitive.
Previous by thread: Shared Buffers
Next by thread: Re: Matching against a field case in-sensitive.
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux