[SQL] Mysterious column "name"

2011-08-09 Thread Nikolay
Good day! I found one strange results for sql-query. create table testtable ( f1 int, f2 int ); insert into testtable(f1, f2) values(1, 100); select testtable.* from testtable; // it is ok select testtable from testtable; // it is ok select testtable.name from testtable; // returns strange r

Re: [SQL] Mysterious column "name"

2011-08-09 Thread Oliveiros d'Azevedo Cristina
Strange... Tables have hidden columns but AFAIK, "name" is not one of them... http://www.postgresql.org/docs/9.0/interactive/ddl-system-columns.html Best, Oliveiros - Original Message - From: "Nikolay" To: Sent: Thursday, August 04, 2011 3:50 PM Subject: [SQL] Mysterious column "na

Re: [SQL] Mysterious column "name"

2011-08-09 Thread Steve Crawford
On 08/09/2011 08:34 AM, Oliveiros d'Azevedo Cristina wrote: Strange... Tables have hidden columns but AFAIK, "name" is not one of them... http://www.postgresql.org/docs/9.0/interactive/ddl-system-columns.html ... Good day! I found one strange results for sql-query. create table testtable (

Re: [SQL] Mysterious column "name"

2011-08-09 Thread Tom Lane
Nikolay writes: > select testtable.name from testtable; // returns strange result. See http://archives.postgresql.org/pgsql-bugs/2010-10/msg00269.php This will change in 9.1: http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=543d22fc7 regards, tom lane -