Re: exposing more parse was: Re: tsearch2: setting weights on tsquery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: exposing more parse was: Re: tsearch2: setting weights on tsquery
Дата
Msg-id 27925.1224610833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: exposing more parse was: Re: tsearch2: setting weights on tsquery  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Ответы tsearch2: setting weights on tsquery plainto_tsquery with | or and weight  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> I missed it. Thanks. Nearly perfect. Now I've to understand what a
> {} is.
> An array with a null element? an empty array? an array containing ''?

Hmm ... it appears that ts_lexize is returning a one-dimensional array of
no elements, whereas '{}'::text[] returns a zero-dimensional array;
as does array[]::text[] so you can't easily get around it :-(

We probably ought to clean this up...

In the meantime it looks like you could check for
"array_upper(lexemes,1) > 0".

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Varchar vs varchar(64)
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: tsearch2: setting weights on tsquery plainto_tsquery with | or and weight