`~' operator and indices
От
Artur Rataj
Тема
`~' operator and indices
Дата
Msg-id
Pine.GSO.4.05.10012201911250.2752-100000@atos
Список
Дерево обсуждения
`~' operator and indices Artur Rataj <arataj@iitis.gliwice.pl>
Re: `~' operator and indices Jie Liang <jliang@jliang.ipinc.com>
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
В списке pgsql-sql по дате отправления