check (constraint) on point data type?

From: "Jill" <jill289(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: check (constraint) on point data type?
Date: 2007-07-24 19:59:14
Message-ID: BAY102-DAV5F941AFBDF619F5CAF73DFFF00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Adams 2007-07-24 20:38:27 Re: check (constraint) on point data type?
Previous Message Tom Lane 2007-07-24 19:47:00 Re: DEFERABLE vs. NOT DEFERABLE constraints