Massa, Harald Armin wrote:
> select ts_parse('default','the quick brown fox jumped over the lazy fox')
>
> (1,the)
> (12," ")
> (1,quick)
> [...]
> (1,fox)
>
> is a set-returning-function, giving me 17 records of type pseudo-record.
> Stopwords still in there, so what. But: No chance of
> a) the lexems of a tsvector
ts_debug (it`s a plain sql function, may give You some inspiration for
Your own queries)
> b) the (unnamed) fields of a set-of-record-returning function
select * from ts_parse('default','the quick brown fox jumped over the lazy fox')
or
select (ts_parse('default','the
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
On Thu, 25 Aug 2011 18:21:21 +0200
"Massa, Harald Armin" wrote:
> I want to access the single words in a text. Better yet: the
> relevant words (i.e. without stop words) in a text.
>
> to_tsvector or casting gets me the lexems as a tsvector:
I wrote this piece of C code more than a year ago. [1
Can this fit?
select plainto_tsquery('english', 'the quick brown fox jumped over the
lazy fox');
plainto_tsquery
-
'quick' & 'brown' & 'fox' & 'jump' & 'lazi' & 'fox'
-Sushant.
On Thu, 2011-08-25 at 18:21
I want to access the single words in a text. Better yet: the relevant words
(i.e. without stop words) in a text.
to_tsvector or casting gets me the lexems as a tsvector:
select to_tsvector('the quick brown fox jumped over the lazy fox')
''brown':3 'fox':4,9 'jump':5 'lazi':8 'quick':2'
And I wou
