>> 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
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=# selec
Tatsuo Ishii wrote:
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?
That code looks badly written in any event. Delimiters should be put around
each part of an identifier or chain
Tatsuo Ishii wrote:
> 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.
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to y
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)
