CREATE TABLE test (foo numeric(8,2) CHECK (foo >= 0.0));
ecdb=> insert into test values (-2.2);
ERROR: new row for relation "test" violates check constraint "test_foo_check"
This is expected.
However, is there a way to insert a null when this check fails,
instead of returning an error (and thus aborting the insert)? I'm
reading on http://www.postgresql.org/docs/current/static/ddl-constraints.html
but cannot find an answer to this question.
pgsql-novice by date
|Next:||From: Victor Hugo||Date: 2010-08-16 18:03:01|
|Subject: Re: Remote Connection to server: Connection Refused|
|Previous:||From: Kavitha Parvataneni||Date: 2010-08-16 17:52:19|
|Subject: Remote Connection to server: Connection Refused|