On 11/11/2010 06:03 PM, Tatsuo Ishii wrote:
Hi, I' wondering if following delimited identifier brhavior is correct or not: test=# create table t1(i int); create table t1(i int); CREATE TABLE test=# create table t1_foo(i int, j int); create table t1_foo(i int, j int); CREATE TABLE test=# select * from t1; select * from t1; i --- (0 rows) test=# select * from t1_foo; select * from t1_foo; i | j ---+--- (0 rows) test=# select * from "t1"_foo; select * from "t1"_foo; i --- (0 rows) It seems PostgreSQL thinks "t1"_foo is equivalent to t1. Is this an expected behavior?
It's treating _foo as an alias in the query for t1. So the behaviour is quite correct, I think.
cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers