| From: | "Basil A(dot) Evseenko" <evseenko(at)msiu(dot)ru> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Strange CREATE VIEW behavior?? |
| Date: | 2001-06-13 14:01:48 |
| Message-ID: | 3B27724B.C0FA5C6@msiu.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
test=# create table zz(ss int, ff varchar);
test=# create view ff2 as select ff as user, ss as num from zz;
test=# create view ff3 as select ff as user1, ss as num from zz;
test=# \d ff2
View "ff2"
Attribute | Type | Modifier
-----------+-------------------+----------
user | character varying |
num | integer |
View definition: SELECT zz.ff AS "user", zz.ss AS num FROM zz;
test=# \d ff3
View "ff3"
Attribute | Type | Modifier
-----------+-------------------+----------
user1 | character varying |
num | integer |
View definition: SELECT zz.ff AS user1, zz.ss AS num FROM zz;
Why in the first case column has name "user" (with '"') ?
PostgreSQL 7.1.2 builded gcc 2.95.3 with options:
./configure --prefix=/usr --sysconfdir=/etc --enable-locale --enable-multibyte=KOI8 --enable-unicode-conversion
--with-tcl --with-perl --with-python --with-openssl --with-CXX --with-gnu-ld --enable-syslog
Linux-2.2.19 on i686, glibc-2.1.3
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-13 14:15:08 | Re: "WHERE col NOT IN" yields falsely empty result. |
| Previous Message | Tom Lane | 2001-06-13 13:30:38 | Re: coalesce in execute crashes backend |