Could it be due to the comma in your CHECK statement instead of a decimal?
-----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jill Sent: Tuesday, July 24, 2007 2:59 PM To: pgsql-novice@postgresql.org Subject: [NOVICE] check (constraint) on point data type?
Hi,
I'd like to limit the values that can be added to a field.
The field is of type 'point', and I'd like it to reject any values less than 0 or bigger than 1 (i.e., accept only points with values like (0.4, 0.26)).
Let's say I try to define the upper boundary by doing:
ALTER TABLE "public"."locations" ADD CONSTRAINT "up_boundary_chk" CHECK (location < (1,1));
