Tom Lane wrote:
>Dmitry Tkach <dmitry@openratings.com> writes:
>
>
>>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
>
>
I know... That was a typo in my sql :-)
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