Re: Matching against a field case in-sensitive.

From: Serge Fonville <serge(dot)fonville(at)gmail(dot)com>
To: James Dooley <jamdooley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Matching against a field case in-sensitive.
Date: 2009-03-02 14:45:25
Message-ID: 680cbe0e0903020645v53ddbe3awabcc9a7c4116a006@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.
>

PostgreSQL has string
functions<http://developer.postgresql.org/pgdocs/postgres/functions-string.html>
,
you can use these in your where clause

Hope this helps.

Regards,

Serge Fonville

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-03-02 14:58:14 Re: Matching against a field case in-sensitive.
Previous Message Gauthier, Dave 2009-03-02 14:40:29 Re: Shared Buffers