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 по дате отправления: