Re: syntax for reaching into records, specifically ts_stat results - Mailing list pgsql-hackers

That works perfectly!

Thanks,
Dan

On Dec 9, 2008, at 3:13 PM, Tom Lane wrote:

> Dan Chak <chak@MIT.EDU> 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 the syntax you need is (stat).word etc.  See "Field Selection"
> here:
> http://www.postgresql.org/docs/8.3/static/sql-expressions.html#AEN1679
> The reason for the parens is exactly to distinguish whether the  
> leading
> word is a table or column name.
>
>             regards, tom lane