Values of fields in Rules - Mailing list pgsql-hackers

From mito
Subject Values of fields in Rules
Date
Msg-id gtp8ts$h4l$1@news.hub.org
Whole thread Raw
Responses Re: Values of fields in Rules  (mito <milos.orszag@gmail.com>)
List 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?



pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: bytea vs. pg_dump
Next
From: Peter Eisentraut
Date:
Subject: Re: ALTER TABLE should change respective views