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 accessing the second > field in that record. What about: select w from ts_parse('default','the quick brown fox jumped over the lazy fox') as lexems(i,w); Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general