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.d <http://www.2ndquadrant.com/>e PostgreSQL Training, Services and Support 2ndQuadrant Deutschland GmbH GF: Harald Armin Massa Amtsgericht Stuttgart, HRB 736399