Case of strings - Mailing list pgsql-general

Hi

I have moved an application from MySQL to PgSQL, and after the making changes I thought all was ok.

However, I have just realised that

Where A = ‘STRING’

Is not the same as

Where A =’String’

Is there anyway I can force the PgSQL to accept case equivalence, or must I add upper()/lower() to force the case and then make string tests?

Ie Where upper(A)=upper(‘String’)

Many thanx

Simon

Simon Windsor

Eml: simon.windsor@cornfield.org.uk

Tel: 01454 617689

Mob: 07960 321599