Re: constraint expression

From: Kris Jurka <books(at)ejurka(dot)com>
To: Roger Niederland <2004(at)niederland(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: constraint expression
Date: 2004-08-09 08:01:57
Message-ID: Pine.BSO.4.56.0408090300450.30738@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 6 Aug 2004, Roger Niederland wrote:

> create table test (a int, b int, c int,
> constraint aname check (((a=0) and (b is not null)) or ((a=1) and (c
> is not null)));
>

You are missing the closing ) for the create table statement.

Kris Jurka

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Connamacher 2004-08-09 08:30:40 Embedded Database
Previous Message Tom Lane 2004-08-09 05:44:19 Re: Losing records when server hang