Postgres Pro
Downloads
Home   >   mailing lists

Matching against a field case in-sensitive. - Mailing list pgsql-general

From James Dooley
Subject Matching against a field case in-sensitive.
Date
Msg-id c01aff630903020640r3dfdccebs34e3021c66391d64@mail.gmail.com
Whole thread Raw
Responses Re: Matching against a field case in-sensitive.  (Serge Fonville <serge.fonville@gmail.com>)
Re: Matching against a field case in-sensitive.  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Matching against a field case in-sensitive.  (Martin Gainty <mgainty@hotmail.com>)
Re: Matching against a field case in-sensitive.  (Reid Thompson <reid.thompson@ateb.com>)
List pgsql-general
Tree view
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.




pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Shared Buffers
Next
From: Serge Fonville
Date:
Subject: Re: Matching against a field case in-sensitive.