From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Can I use check-constraint to set null? |
Date: | 2010-08-16 18:34:36 |
Message-ID: | 20100816183436.GB20846@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Rikard Bosnjakovic <rikard(dot)bosnjakovic(at)gmail(dot)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°
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2010-08-16 18:43:48 | Re: Can I use check-constraint to set null? |
Previous Message | Andreas Kretschmer | 2010-08-16 18:33:24 | Re: Remote Connection to server: Connection Refused |