'enum' equivalent?

From: Dan Lyke <danlyke(at)flutterby(dot)com>
To: Steve Leibel <stevel(at)bluetuna(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: 'enum' equivalent?
Date: 2001-01-22 18:50:32
Message-ID: 14956.33016.894496.485456@wynand.flutterby.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

Steve Leibel writes:
> I'm converting a mysql database to postgres. Is there an equivalent
> for the enum data type?

No, but you can put the enum data in a separate table and join
them. This also makes the operation of adding entries to the enum list
better defined.

Dan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian E. Pangburn 2001-01-22 19:07:15 [General] Comments
Previous Message Steve Wolfe 2001-01-22 18:20:54 "recovery mode"

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2001-01-22 19:53:50 Generating History
Previous Message Mikheev, Vadim 2001-01-22 18:03:36 RE: Beta 3 question(s)

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Mount 2001-01-22 20:40:53 Re: postgres memory management
Previous Message Kogotkov, Vyacheslav 2001-01-22 16:26:39 JDBC2 question -- can't find files needed