| From: | Jürgen Hauser <hauser(at)pandora(dot)be> |
|---|---|
| To: | "Nils O(dot)" Selåsdal <nos(at)utel(dot)no> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Enum in PostgreSQL - How to |
| Date: | 2003-04-07 14:41:31 |
| Message-ID: | 5.1.0.14.2.20030407164030.00ab40a0@in.telenet.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-07 14:50:26 | Re: possible time change issue - known problem? |
| Previous Message | Dan Langille | 2003-04-07 14:40:53 | Re: possible time change issue - known problem? |