Re: [HACKERS] syntax for reaching into records, specifically ts_stat results

2008-12-09 Thread Dan Chak
That works perfectly! Thanks, Dan On Dec 9, 2008, at 3:13 PM, Tom Lane wrote: Dan Chak <[EMAIL PROTECTED]> writes: If I say stat.word (instead of subscripting), I get 'missing FROM- clause entry for table "stat"'. If I say foo.stat.word, I get 'ERROR: sc

Re: [HACKERS] syntax for reaching into records, specifically ts_stat results

2008-12-09 Thread Dan Chak
tiple tsvectors as I'm doing below. Is there some generic record access syntax that I can use? Thanks, Dan On Dec 9, 2008, at 3:04 PM, Oleg Bartunov wrote: try select * from ts_stat() btw, performance of ts_stat() was greatly improved in 8.4. Oleg On Tue, 9 Dec 2008, Dan Chak wrote:

[HACKERS] syntax for reaching into records, specifically ts_stat results

2008-12-09 Thread Dan Chak
Dear Postgres Folk, In working with tsvectors (added in 8.3), I've come to a place where my syntax-fu has failed me. I've resorted to turning a result set of records into strings so that I can regexp out the record fields I need, rather than access them directly, as I'm sure it's possible