Postgres Pro
Downloads
Home   >   mailing lists

Re: best way to handle enum type - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: best way to handle enum type
Date
Msg-id 200711220059.02550.peter_e@gmx.net
Whole thread Raw
In response to best way to handle enum type  (Tom Hart <tomhart@coopfed.org>)
Responses Re: best way to handle enum type  (Tom Hart <tomhart@coopfed.org>)
List pgsql-general
Tree view 
Tom Hart wrote:
> Hey everybody. I have a field that, in my earlier mySQL days would have
> been an enum('q','y','m','c'), and I'm wondering what's the best way to
> handle this in pgsql.

If it's an option, upgrade to 8.3 and use the new enum support.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fragments in tsearch2 headline
Next
From: Richard Broersma Jr
Date:
Subject: Re: POLL: Women-sized t-shirts for PostgreSQL