| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Are globally defined constants possible at all ? |
| Date: | 2002-06-07 21:31:48 |
| Message-ID: | Pine.LNX.4.21.0206072228490.2635-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-06-07 21:49:41 | Re: Are globally defined constants possible at all ? |
| Previous Message | Gregory Seidman | 2002-06-07 21:29:27 | Re: Are globally defined constants possible at all ? |