Skip site navigation (1) Skip section navigation (2)

Strange CREATE VIEW behavior??

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 (view raw or flat)
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


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-06-13 14:15:08
Subject: Re: "WHERE col NOT IN" yields falsely empty result.
Previous:From: Tom LaneDate: 2001-06-13 13:30:38
Subject: Re: coalesce in execute crashes backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group