Re: Are globally defined constants possible at all ? - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: Are globally defined constants possible at all ?
Date
Msg-id Pine.LNX.4.21.0206072228490.2635-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: Are globally defined constants possible at all ?  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: Are globally defined constants possible at all ?  (Darren Ferguson <darren@crystalballinc.com>)
List pgsql-general
On Fri, 7 Jun 2002, Andrew Sullivan wrote:

> On Fri, Jun 07, 2002 at 02:36:35PM -0400, Gregory Seidman wrote:
>
> > I am in the exact same position. I have a number of things which are
> > essentially enumerations. Since PostgreSQL does not support an enumeration
> > type (MySQL does, but then it doesn't have a proper boolean type), I have a
>
> Why don't you use a CHECK contraint?  That's the standard way to do
> it.

I wonder if you could explain how to use CHECK for this please? I'm having a
little trouble thinking in that manner but then I've only seen and used the
table associating name and value method before and so am a little biased.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants


pgsql-general by date:

Previous
From: Gregory Seidman
Date:
Subject: Re: Are globally defined constants possible at all ?
Next
From: Darren Ferguson
Date:
Subject: Re: Are globally defined constants possible at all ?