Re: [HACKERS] Values of fields in Rules

2009-05-06 Thread Bernd Helmle
--On Dienstag, Mai 05, 2009 20:25:54 -0400 Alvaro Herrera alvhe...@commandprompt.com wrote: Not that I know of (and yes, this sucks). But doesn't this also apply to triggers? I can't think of a reliable way to distinguish specified or unspecified fields in trigger functions as

[HACKERS] Values of fields in Rules

2009-05-05 Thread mito
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

Re: [HACKERS] Values of fields in Rules

2009-05-05 Thread mito
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

Re: [HACKERS] Values of fields in Rules

2009-05-05 Thread Alvaro Herrera
mito escribió: is there any way how to determinate in rule that null comes from explicit insert or from not naming column in insert statment Not that I know of (and yes, this sucks). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication,