Thank for the tips, Oliver and Paul! I take it then that there are no
means of constructing collation tables (like I do in FrontBase), that
allow me to control which characters are equalled with which characters
in searches - this is a part of SQL92, I believe.
Jens
On Sunday, Jan 26, 2003, at 13:54 Europe/Copenhagen, Oliver Elphick
wrote:
> On Sun, 2003-01-26 at 07:13, Jens Østergaard Petersen wrote:
>> 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?
>
> You can use ILIKE or you can use a regular expression with the ~*
> operator.
>
> --
> Oliver Elphick Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
> ========================================
> "Wash me thoroughly from mine iniquity, and cleanse me
> from my sin. For I acknowledge my transgressions; and
> my sin is ever before me. Against thee, thee only,
> have I sinned, and done this evil in thy sight..."
> Psalms 51:2-4
>
