check constraint

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: check constraint
Date: 2000-12-18 15:30:06
Message-ID: 00121812300603.21897@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
how should I write a constraint that can keep an INT field with values
between 0 and 10? Do I have to use two checks on the same field?

TIA

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wade D. Oberpriller 2000-12-18 15:43:26 Re: check constraint
Previous Message Tom Lane 2000-12-18 15:18:44 Re: More on character encoding in SELECTs