Re: Enum in PostgreSQL - How to - Mailing list pgsql-general

From Jürgen Hauser
Subject Re: Enum in PostgreSQL - How to
Date
Msg-id 5.1.0.14.2.20030407164030.00ab40a0@in.telenet.be
Whole thread Raw
In response to Re: Enum in PostgreSQL - How to  ("Nils O." Selåsdal <nos@utel.no>)
List pgsql-general
Yes thank you very much, i just figured it out.

At 16:03 07.04.2003 +0200, you wrote:
>On Mon, 2003-04-07 at 14:24, Jürgen Hauser wrote:
> > Hello!
> >
> > Could somebody tell me how i would simulate an ENUM columntype (as in
> > MySQL). For example:
> >
> > accountType ENUM('default', 'custom') default='default'
>accountType varchar(10) CHECK (accountType='default' or
>accountType='custom) DEFAULT 'default'
>
>
>--
>Vennlig hilsen/Best Regards
>Nils Olav Selåsdal
>System Engineer
>UtelSystems a/s
>Tlf: 370 45 431
>Mob: 416 97 995
>w w w . u t e l s y s t e m s . c o m
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: unable to dump database, toast errors
Next
From: "Dan Langille"
Date:
Subject: Re: possible time change issue - known problem?