That works perfectly!
Thanks,
Dan
On Dec 9, 2008, at 3:13 PM, Tom Lane wrote:
> Dan Chak <chak(at)MIT(dot)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