Re: Can I use check-constraint to set null?

Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com> wrote:

> (Postgres 8.4.2)
>
> 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.

I think, you should use a TRIGGER.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°