Delimited identifier brhavior
От | Tatsuo Ishii |
---|---|
Тема | Delimited identifier brhavior |
Дата | |
Msg-id | 20101112.080350.91516597177315965.t-ishii@sraoss.co.jp обсуждение исходный текст |
Ответы |
Re: Delimited identifier brhavior
Re: Delimited identifier brhavior Re: Delimited identifier brhavior |
Список | pgsql-hackers |
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? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления: