Re: null constraints and defaults

Thanks.  I understand that much.  I want to know if this
is the intended behaviour.

--elein

On Wed, Jun 29, 2005 at 08:25:09PM +0000, Matt Miller wrote:
> On Wed, 2005-06-29 at 13:04 -0700, elein wrote:
> > default constraint
> > ...
> > elein=# insert into nulldefault values (NULL);
> > ERROR:  null value in column "one" violates not-null constraint
>
> I think the idea of a DEFAULT value is to tell the DB what to supply
> only if you omit the column from the insert statement altogether.  If
> you deliberately call for a NULL, the DB will try to oblige.
>