Case sensitivity issue

From: mike7411(at)earthlink(dot)net (Michael Gay)
To: pgsql-general(at)postgresql(dot)org
Subject: Case sensitivity issue
Date: 2001-09-10 04:02:59
Message-ID: 61ca1926.0109092002.83baf57@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I am doing a command such as

select * from Apples where color like '%red%';

how do I make it case insensitive?

Thanks.

mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Graham White 2001-09-10 05:03:44 Repairing table corruption
Previous Message Joe Conway 2001-09-10 02:00:31 Re: Primary keys and speed