On 16 August 2010 19:34, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
> 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.
>
I don't think suicide's the answer. Oh, wait, I see...
--
Thom Brown
Registered Linux user: #516935