Re: Issue with default values and Rule - Mailing list pgsql-general

Yes, there you are. Changing the order in coalesce will not solve the issue here. As update will also have some real non-null NEW values.

Actually internally when the rule gets called then default value is being in this case.

However note that 'null' is being explicitly inserted then default value is not picked by postgres engine internally and data is persisted correctly:

      create table my_test (id int, col_1 timestamp null, col_2 varchar(12) null default 'Initial');

      insert into my_test(id,col_1,col_2) values(1, now() at time zone 'UTC','ShowMe');
      select * from my_test;
      Results:
      1,2014-02-27 16:34:23.464088,ShowMe

      insert into my_test(id,col_1,col_2) values(1, now() at time zone 'UTC',null);
      select * from my_test;

      Results:

      1,2014-02-27 16:35:49.206237,ShowMe

Agree trigger might give more control here. But still suggest any breakthrough here.

Regards...