From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Artem Chuprina <ran(at)pirit(dot)com> |
Subject: | INSERT into VIEW |
Date: | 1999-06-06 14:08:22 |
Message-ID: | Pine.SOL2.3.96.SK.990606180614.1940A-100000@sun.med.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.
From | Date | Subject | |
---|---|---|---|
Next Message | Kaare Rasmussen | 1999-06-06 14:35:14 | Re: [HACKERS] Priorities for 6.6 |
Previous Message | Vadim Mikheev | 1999-06-06 13:32:36 | Re: [HACKERS] Bizarre coding in _bt_binsrch |