Message-ID: <363843C3.D50853FF@sferacarta.com>
Date: Thu, 29 Oct 1998 11:30:27 +0100
From: "Jose' Soares" <jose@sferacarta.com>
MIME-Version: 1.0
To: Constantin Teodorescu <teo@flex.ro>
CC: PostgreSQL general <pgsql-general@postgresql.org>,
	PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Does "constraint" and "check" work in 6.3.2 ?
References: <36376670.E573456E@flex.ro>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Constantin,

This is a syntax problem, there are two kinds of constraints (table and
column constraints)
and both of them must be defined inside ( ) not outside:

create table emppay (
        name text not null check (name <> ''),                  --column
constraint definition
        wage float4 default 10.00,
        constraint empcon check (wage > 5.30 and wage <= 30.00) --table
constraint definition
        );
CREATE

       Jose'

Constantin Teodorescu wrote:
> 
> I am planning a new release to PgAccess (mainly bug fixes) and I'm
> wondering if "constraint" and "check" are working !
> I am using PostgreSQL 6.3.2 and this example from man create_table is
> not working for me !
> 
> Please reply as soon as possible, so I could release this version prior
> to 6.4 Pg release.
> 
> testdb=> create table emppay (name text not null, wage float4 default
> 10.00)  constraint empcon check (wage > 5.30 and wage <= 30.00), check
> (name <> '');
> ERROR:  parser: parse error at or near "constraint"
>