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

On Thu, Oct 6, 2011 at 4:37 PM, Gavin Flower
<GavinFlower(at)archidevsys(dot)co(dot)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.