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