>> It seems PostgreSQL thinks "t1"_foo is equivalent to t1. > > It thinks you've given "t1" an alias of "_foo" in that query, same > as if you'd had a space between "t1" and _foo.
Oh, ok. I thought we always need at least one space character between the table name and the alias. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers