| 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: | Whole Thread | Raw Message | 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
| 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" |
| 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) |
| 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 |