| From: | Jens Østergaard Petersen <oesterg(at)hum(dot)ku(dot)dk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: collation |
| Date: | 2003-01-26 17:05:23 |
| Message-ID: | 5B6B9F92-3150-11D7-ACB7-000393864A30@hum.ku.dk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(dot)Elphick(at)lfix(dot)co(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Art Fore | 2003-01-26 17:28:52 | postgresql with SuSE 8.0 |
| Previous Message | paul butler | 2003-01-26 12:51:28 | Re: collation |