Possible Bug - Mailing list pgsql-general

From Kaloyan Iliev Iliev
Subject Possible Bug
Date
Msg-id 4D5263AA.9050807@digsys.bg
Whole thread Raw
Responses Re: Possible Bug  (Robert Gravsjö <robert@blogg.se>)
Re: Possible Bug  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hi,
I think I found something strange in PostgreSQL behavior. Here is an
example:


testdb=# CREATE TABLE test1 (test2 text, test3 text);
CREATE TABLE
testdb=# SELECT A.name FROM test1 A;
 name
------
(0 rows)

testdb=#  INSERT INTO test1 (test2,test3) VALUES ('1','2');
INSERT 0 1
testdb=# INSERT INTO test1 (test2,test3) VALUES ('3','4');
INSERT 0 1
testdb=# SELECT A.name FROM test1 A;
 name
-------
 (1,2)
 (3,4)
(2 rows)

customer.20080408=# SELECT name FROM test1;
ERROR:  column "name" does not exist
LINE 1: SELECT name FROM test1;


testdb=# SELECT version();

version
----------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.5 on amd64-portbld-freebsd8.1, compiled by GCC cc (GCC)
4.2.1 20070719  [FreeBSD], 64-bit
(1 row)

Obviously there is no column with name "name", but the SELECT query
(ONLY WHEN I USE ALIASES) returns result for it.
And if I have a column with name "name_en" and by mistake write it
"name", instead of error I receive strange data (ARRAY from all
columns), that I don't expect.

Could you tell me if this is a bug or some feature I haven't heard of.

Best regards,
 Kaloyan Iliev



pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: [HACKERS] Issues with generate_series using integer boundaries
Next
From: michel wildcat
Date:
Subject: créer une DLL pour Postgresql 9 avec visual C++ [2008]