Re: Check constraint

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, gwood(at)ewebengine(dot)com, pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Check constraint
Date: 2004-03-17 12:55:22
Message-ID: 20040317125306.B13349@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 17 Mar 2004, Stephan Szabo wrote:

> Actually, shouldn't a table level check constraint be able to do this with
> something like:
> check (purchase_type!=3 or comment is not null)

That worked Stephan.

Gregory. I think yours would work too. Saw Stephans answer and tested
before I saw your email.

Thanks guys.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jerry LeVan 2004-03-17 13:51:31 Wrapping query results in XML?
Previous Message Francisco Reyes 2004-03-17 12:03:04 Check constraint