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

Reply via email to