Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 63CA2B5DBDB for ; Tue, 9 Aug 2011 12:34:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 93506-09 for ; Tue, 9 Aug 2011 15:34:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.marktest.pt (iota.marktest.pt [80.251.174.118]) by mail.postgresql.org (Postfix) with ESMTP id BDCF4B5D80A for ; Tue, 9 Aug 2011 12:34:29 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.marktest.pt (Postfix) with ESMTP id 73B2D1A8888; Tue, 9 Aug 2011 16:34:27 +0100 (WEST) X-Virus-Scanned: amavisd-new at marktest.pt Received: from hermes.marktest.pt ([127.0.0.1]) by localhost (hermes.marktest.pt [127.0.0.1]) (amavisd-new, port 11124) with ESMTP id uIvrvfcq3BWy; Tue, 9 Aug 2011 16:34:27 +0100 (WEST) Received: from Proteu (proteu.marktest.pt [10.61.90.54]) by hermes.marktest.pt (Postfix) with ESMTP id 5BCAD1A8887; Tue, 9 Aug 2011 16:34:27 +0100 (WEST) Message-ID: <80B8AE0F6EA345ECB04802EB381EF1B1@marktestcr.marktest.pt> From: "Oliveiros d'Azevedo Cristina" To: "Nikolay" , References: <4E3AB1B2.5040704@gmail.com> Subject: Re: Mysterious column "name" Date: Tue, 9 Aug 2011 16:34:26 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.711 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.812, WEIRD_QUOTING=0.001 X-Spam-Level: X-Archive-Number: 201108/27 X-Sequence-Number: 35695 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 "name" > 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@126.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. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql