Postgres Pro
Downloads
Home   >   mailing lists

Case (in)sensitive - Mailing list pgsql-novice

From Boszormenyi Laszlo
Subject Case (in)sensitive
Date
Msg-id Pine.LNX.4.21.0009231821150.26885-100000@jupiter.hlab.uni-miskolc.hu
Whole thread Raw
List pgsql-novice
Tree view 
Hello!

 I have a database with city names, so the first letter is capitalised.
I want to let the user search for part of the city name. How can I do case
insensitive for this? You know "... like '%bud%';" won't find Budapest.

Thanks in advance,
    Laszlo Boszormenyi

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Re: add or subtract days from a 'date' in query
Next
From: Tom Lane
Date:
Subject: Re: [SQL] how to store a query, that results in a table