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 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
