From: | "Jim Adams" <postgres(at)drakeenterprises(dot)org> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: check (constraint) on point data type? |
Date: | 2007-07-24 20:38:27 |
Message-ID: | 008101c7ce32$9711c7c0$6501a8c0@CAPTDRAKE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Could it be due to the comma in your CHECK statement instead of a decimal?
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Jill
Sent: Tuesday, July 24, 2007 2:59 PM
To: pgsql-novice(at)postgresql(dot)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));
but it fails.
What am I doing wrong?
I'm using Postgres 8.2.4.1
Thanks!
Jill
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2007-07-24 21:06:21 | Re: check (constraint) on point data type? |
Previous Message | Jill | 2007-07-24 19:59:14 | check (constraint) on point data type? |