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
-
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 (
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
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
