Re: Views and default values

On Fri, Apr 06, 2001 at 12:24:09PM +0100, Michael Ansley wrote:
> >>  Data Base:
> >>
> >>      create table foo (
> >>         cod            serial primary key,
> >>         explication    text,
> >>         silly        bool default 't');
> >>
> >>     create view v_foo as
> >>         select * from foo;
> >>
> >>     create rule v_foo_ins as on insert to v_foo do instead
> >>         insert into foo values (
> >>             NEW.cod,
> >>             NEW.explication,
> >>             NEW.silly);
> You should probably have this:
>
> create rule v_foo_ins as on insert to v_foo do instead
>     insert into foo (explication, silly) values (
>         NEW.explication,
>         NEW.silly);
>
> The rule is trying to insert NEW.cod, which is null, into the table.  This
> rule let's the cod field take care of itself.

 That is valid for 'cod' but not for 'silly'. I'd like that if insert value
 is null, then I get default value, but if insert value is not null, this is
 value that is saved.

 Any idea?...

 Thanks.

                                             David