FAQ
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.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJun 6, '99 at 2:08p
activeJun 6, '99 at 7:33p
posts2
users2
websitepostgresql.org...
irc#postgresql

2 users in discussion

Oleg Broytmann: 1 post Jan Wieck: 1 post

People

Translate

site design / logo © 2021 Grokbase