Re: collation - Mailing list pgsql-novice

From paul butler
Subject Re: collation
Date
Msg-id 07f680855121a13PCOW034M@blueyonder.co.uk
Whole thread Raw
In response to collation  (Jens Østergaard Petersen <oesterg@hum.ku.dk>)
List pgsql-novice
Date sent:          Sun, 26 Jan 2003 08:13:56 +0100
Subject:            [NOVICE] collation
From:               Jens Østergaard Petersen <oesterg@hum.ku.dk>
To:                 pgsql-novice@postgresql.org

Would this do the trick?

select x from y where upper(x) =upper('TestString');

Hope this helps

Paul Butler
Hi!

I have been looking all around, but I don't see any support for
collation in pgsql - are there other ways of performing
cases-insensitive searches?

Cheers,

Jens


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-novice by date:

Previous
From: Jens Østergaard Petersen
Date:
Subject: collation
Next
From: Jens Østergaard Petersen
Date:
Subject: Re: collation