Mysterious column "name"

From: Nikolay <wheelly(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Mysterious column "name"
Date: 2011-08-04 14:50:26
Message-ID: 4E3AB1B2.5040704@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 result.
-----------------------------------------------------------------
name
name
-----------------------------------------------------------------
"(1,100)"
-----------------------------------------------------------------
no error message about nonexistent column.
Result is similar to second variant, but pgAdmin3 shows not full record.

for long table the result is truncated
select aaaaaa."name"
from yc_accounts aaaaaa
-----------------------------------------------------------------
name
name
-----------------------------------------------------------------
"(1154,81,testtter,"","","","","","","","","",donald22(at)126(dot)com,""
-----------------------------------------------------------------

The same results on two servers.
PostgreSQL 9.0.4 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit

PostgreSQL 9.0.4 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real
(Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit

Is it a feature or a bug? I didn't found information in documentation
about this.

Best regards.
Nikolay.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Charlie 2011-08-04 21:54:05 Re: Calculating relative time/distance from CURRENT_TIMESTAMP
Previous Message Gnanakumar 2011-08-04 11:42:51 Re: Calculating relative time/distance from CURRENT_TIMESTAMP