mito wrote:
> Hi,
>
> when i create rule(on insert) on view(select id, name from users), i
> will recieve values that were inserted in form of reference words
> new.id, new.name.
>
> if i insert into users (id, name) values (null, null);
> then new.id = null and new.name = null
>
> if i insert into users (name) values (null);
> then new.id = null and new.name = null
>
> is there any way how to distinguish that id column wasnt explicitly named?
>
is there any way how to determinate in rule that null comes from
explicit insert or from not naming column in insert statment