Can I use check-constraint to set null?

From: Rikard Bosnjakovic <rikard(dot)bosnjakovic(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can I use check-constraint to set null?
Date: 2010-08-16 18:01:55
Message-ID: AANLkTik6wgxKakmQz1-Lx_0EJC41oydbfuubWhywrk03@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

(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.

--
- Rikard

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Victor Hugo 2010-08-16 18:03:01 Re: Remote Connection to server: Connection Refused
Previous Message Kavitha Parvataneni 2010-08-16 17:52:19 Remote Connection to server: Connection Refused