Re: [SQL] Case in-sensitive searches

From: Marin D <marin(at)iclub(dot)techno-link(dot)com>
To: Jerome Knobl <jknobl(at)mandanet(dot)ch>
Cc: Mike Lemler <coronach(at)datacruz(dot)com>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Case in-sensitive searches
Date: 1998-05-19 07:54:53
Message-ID: Pine.LNX.3.96.980519105339.3276B-100000@server.iclub.techno-link.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


upper()/lower() are defined only for text fields. How to deal with charN ?

Thanx for the attention!

Marin

-= Why do we need gates in a world without fences? =-

On Tue, 19 May 1998, Jerome Knobl wrote:

> Hi,
>
> I found an inellegant sollution. You can put every character in uppercase
> like that :
>
> Select * From table_membres where upper(nom) like upper('myname');
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-05-19 09:45:18 Re: [SQL] How to handle a requirement for nextval
Previous Message Herouth Maoz 1998-05-19 07:27:50 Re: [SQL] How to handle a requirement for nextval