From: | mito <milos(dot)orszag(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Values of fields in Rules |
Date: | 2009-05-05 11:46:07 |
Message-ID: | gtp8ts$h4lgtp8ts$h4l$1@news.hub.org@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2009-05-05 12:40:28 | Re: ALTER TABLE should change respective views |
Previous Message | Matthew Wakeling | 2009-05-05 11:24:42 | Re: [HACKERS] high shared buffer and swap |