Quick Links

Matching against a field case in-sensitive.

From:	James Dooley <jamdooley(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Matching against a field case in-sensitive.
Date:	2009-03-02 14:40:27
Message-ID:	c01aff630903020640r3dfdccebs34e3021c66391d64@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Re: Matching against a field case in-sensitive. at 2009-03-02 14:45:25 from Serge Fonville
Re: Matching against a field case in-sensitive. at 2009-03-02 14:58:14 from A. Kretschmer
Re: Matching against a field case in-sensitive. at 2009-03-02 15:18:06 from Martin Gainty
Re: Matching against a field case in-sensitive. at 2009-03-02 15:21:26 from Reid Thompson

Browse pgsql-general by date

	From	Date	Subject
Next Message	Gauthier, Dave	2009-03-02 14:40:29	Re: Shared Buffers
Previous Message	Grzegorz Jaśkiewicz	2009-03-02 13:48:27	Re: Shared Buffers