Dmitry Tkach <[EMAIL PROTECTED]> writes:I know... That was a typo in my sql :-)
testdb=# create table test_view as select * from test;
SELECT
That is not a view, it's only a static copy of the original table.
regards, tom lane
But for this example it doesn't matter - that view/table is only needed to illustrate the rules behaviour on insert.
You can just replace 'table' with 'view' in that statement - the behaviour of the insert is exactly the same anyway.
Dima
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend