text search synonym dictionary anomaly with numbers
| От | Richard Greenwood |
|---|---|
| Тема | text search synonym dictionary anomaly with numbers |
| Дата | |
| Msg-id | CAHBySPY9s-uLVhBoNLBVK1cz1yE3APRJVRfA3U5Xp=_zBpFXHw@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: text search synonym dictionary anomaly with numbers
|
| Список | pgsql-general |
I am working with street address data in which 'first st' has been
entered as '1 st' and so on. So I have created a text search
dictionary with entries:
first 1
1st 1
And initially it seems to be working properly:
SELECT ts_lexize('rwg_synonym','first');
ts_lexize
-----------
{1}
SELECT ts_lexize('rwg_synonym','1st');
ts_lexize
-----------
{1}
But my queries on '1st' are not returning the expected results:
SELECT count(*) FROM parcel_attrib WHERE txtsrch @@ to_tsquery('1');
count
-------
403 <- this is what I want
SELECT count(*) FROM parcel_attrib WHERE txtsrch @@ to_tsquery('first');
count
-------
403 <- this is also good
SELECT count(*) FROM parcel_attrib WHERE txtsrch @@ to_tsquery('1st');
count
-------
4 <- this is not good. There are 4 records that do have '1st',
but why am I not getting 403 records?
Thanks for reading,
Rich
--
Richard Greenwood
richard.greenwood@gmail.com
www.greenwoodmap.com
В списке pgsql-general по дате отправления: