Search Postgresql Archives

How to get char indices from text parser | tsvector?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all, 

is there any possibility to get char "coordinates", not only token "coordinates" from tsvector or, basically, text parser? Like in Elasticsearch 


GET _analyze?text=This fox is brown&analyzer=english
{
"tokens": [
{
  "token": "fox",
  "start_offset": 5,
  "end_offset": 8,

  "type": "",
  "position": 1
}


while in PostgreSQL 

SELECT to_tsvector('This fox is brown')
'brown':4 'fox':2 'is':3 'this':1



--

Best Regards,
Roman Gurinovich



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux