Re: ts_rank error/result of '1e-020'

Поиск
Список
Период
Сортировка
От Henry Drexler
Тема Re: ts_rank error/result of '1e-020'
Дата
Msg-id CAAtgU9RycF1gLtmVufV=PrGkei7VDo28vroGfeN17nbQU+yFUg@mail.gmail.com
обсуждение исходный текст
Ответ на ts_rank error/result of '1e-020'  (Henry Drexler <alonup8tb@gmail.com>)
Ответы Re: ts_rank error/result of '1e-020'
Список pgsql-general


On Thu, Oct 6, 2011 at 4:37 PM, Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:
On 07/10/11 01:40, Henry Drexler wrote:
I have a workaround to the error/result, but am wondering what the result of ts_rank of '1e-020' represents?

Here is the original:

select
ts_rank(to_tsvector('a_a_do_ug_read_retreqmon_ptam'),to_tsquery('a_a_do_ug_read_retrmso.com_ptam'))


I get essentialy the same result with pg 9.1.1

----------------
 9.99999968e-21
(1 row)

gavin=>

I am also on "PostgreSQL 9.1.1"

Thanks for posting the   9.99999968e-21, I did not realize it was using notation to represent a number, I thought it was an error code.  That is good news - thank you for taking the time ans showing me your result - that solves it.

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

Предыдущее
От: "Dickson S. Guedes"
Дата:
Сообщение: Re: Tuning Variables For PostgreSQL
Следующее
От: Samba
Дата:
Сообщение: Re: Backup Database Question