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
2010/3/30 Pavel Stehule pavel.steh...@gmail.com:
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
Ian Barwick barw...@gmail.com writes:
2010/3/30 Pavel Stehule pavel.steh...@gmail.com:
we can use a non existing column name. What does mean?
FYI this has caused me (and presumably a few other people) a bit of
head-scratching, e.g.:
2010/3/30 Tom Lane t...@sss.pgh.pa.us:
Ian Barwick barw...@gmail.com writes:
2010/3/30 Pavel Stehule pavel.steh...@gmail.com:
we can use a non existing column name. What does mean?
FYI this has caused me (and presumably a few other people) a bit of
head-scratching, e.g.: