Postgres Pro
Downloads
Home   >   mailing lists

Re: access to lexems or access to parsed elements - Mailing list pgsql-general

From Massa, Harald Armin
Subject Re: access to lexems or access to parsed elements
Date
Msg-id CAMSP2L71w=6Zrnse1CL3XCKAi7Xj4NdsjCbSuYcU3G9nPWwiOA@mail.gmail.com
Whole thread Raw
In response to Re: access to lexems or access to parsed elements  (Sushant Sinha <sushant354@gmail.com>)
List pgsql-general
Tree view
Sushant,

Can this fit?

select plainto_tsquery('english', 'the quick brown fox jumped over the
lazy fox');
                  plainto_tsquery
-----------------------------------------------------
 'quick' & 'brown' & 'fox' & 'jump' & 'lazi' & 'fox'

no, this cannot fit. This just adds a third variation, this time a tsquery object. There is no way to access the single words in that ts_query  programmatically (besides the ugly  "cast to text and split at &')

Harald



--
Harald Armin Massa     www.2ndQuadrant.de
PostgreSQL  Training, Services  and Support

2ndQuadrant Deutschland GmbH     
GF: Harald Armin Massa
Amtsgericht Stuttgart, HRB 736399

pgsql-general by date:

Previous
From: Niyas
Date:
Subject: Re: backup-strategies for large databases
Next
From: Condor
Date:
Subject: COPY FROM how long should take ?