Re: access to lexems or access to parsed elements

From: "Massa, Harald Armin" <harald(at)2ndQuadrant(dot)de>
To: sushant354(at)gmail(dot)com
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: access to lexems or access to parsed elements
Date: 2011-08-26 11:53:29
Message-ID: CAMSP2L71w=6Zrnse1CL3XCKAi7Xj4NdsjCbSuYcU3G9nPWwiOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2011-08-26 12:09:44 COPY FROM how long should take ?
Previous Message Niyas 2011-08-26 11:06:20 Re: backup-strategies for large databases