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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers