Received: from flex.flex.ro (IDENT:root@flex.flex.ro [193.230.255.2])
	by hub.org (8.9.1/8.9.1) with ESMTP id NAA19335;
	Wed, 28 Oct 1998 13:49:08 -0500 (EST) (envelope-from teo@flex.ro)
Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro
	(8.9.1/8.9.1) with ESMTP id CAA02095; Wed, 28 Oct 1998 02:30:32 +0200
Sender: teo@flex.flex.ro
Message-ID: <36376670.E573456E@flex.ro>
Date: Wed, 28 Oct 1998 18:46:08 +0000
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting
X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL general <pgsql-general@postgreSQL.org>,
	PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Does "constraint" and "check" work in 6.3.2 ?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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"

???!????

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA