`~' operator and indices

From: Artur Rataj <arataj(at)iitis(dot)gliwice(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: `~' operator and indices
Date: 2000-12-20 18:38:30
Message-ID: Pine.GSO.4.05.10012201911250.2752-100000@atos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I would like to ask you why do `~' gives the following results,
if there is an index on `string':

select string from indextbk_fti_fkey where string ~ '^IE';
string
--------
(0 rows)

select string from indextbk_fti_fkey where string ~ '^IECIA';
string
--------
IECIA
(1 row)

`E' here is a polish letter. I have set locale to `pl_PL' before
starting postgres.

Best regards

Artur Rataj

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2000-12-20 18:59:45 Re: how to alter/drop check contraint?
Previous Message hubert depesz lubaczewski 2000-12-20 13:10:56 how to alter/drop check contraint?