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
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:
Dear Postgres Folk
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: schema foo does not exist'.
I think