Hello,
I was noticed on little bit strange feature of PostgreSQL 8.4 and 9.0
we can use a non existing column "name". What does mean?
postgres=# create table h(a int, b int);
CREATE TABLE
Time: 2,604 ms
postgres=# insert into h values(199,22);
INSERT 0 1
Time: 0,970 ms
postgres=# explain verbose select h.name from h;
QUERY PLAN
-------------------------------------------------------------
Seq Scan on public.h (cost=0.00..42.10 rows=2140 width=32)
Output: (h.*)::name
(2 rows)
Time: 0,727 ms
postgres=# select h.name from h;
name
----------
(199,22)
(1 row)
Time: 0,589 ms
postgres=#
Regards
Pavel Stehule
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
