From: | Jie Liang <jliang(at)jliang(dot)ipinc(dot)com> |
---|---|
To: | Artur Rataj <arataj(at)iitis(dot)gliwice(dot)pl> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: `~' operator and indices |
Date: | 2000-12-21 00:22:39 |
Message-ID: | Pine.BSF.4.21.0012201621190.45062-100000@jliang.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi, there,
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
On Wed, 20 Dec 2000, Artur Rataj wrote:
> 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';
===> try this:
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Sawtell | 2000-12-21 05:59:47 | Re: Don't understand creation statement's answer |
Previous Message | Jie Liang | 2000-12-21 00:18:01 | Re: plpgsql ? |