INSERT into VIEW
Oleg Broytmann <phd@sun.med.ru>
From: Oleg Broytmann <phd@sun.med.ru>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Artem Chuprina <ran@pirit.com>
Date: 1999-06-06T14:08:22Z
Lists: pgsql-hackers
Hello!
PostgreSQL 6.4.2.
ran=> create table t (some_number int4, some_string text);
CREATE
ran=> insert into t values(-1,'a');
INSERT 20362 1
ran=> insert into t values(1,'d');
INSERT 20363 1
ran=> create view v as select * from t where some_number>=0;
CREATE
ran=> insert into v values (17,'q');
INSERT 20375 1
ran=> select * from t;
some_number|some_string
-----------+-----------
-1|a
1|d
(2 rows)
What is 20375? Is it real OID of dummy row?
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.