From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Delimited identifier brhavior |
Date: | 2010-11-12 00:08:03 |
Message-ID: | 4CDC8563.1030603@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Itagaki Takahiro | 2010-11-12 01:27:18 | Re: MULTISET and additional functions for ARRAY |
Previous Message | Darren Duncan | 2010-11-11 23:32:12 | Re: Delimited identifier brhavior |