| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
| Subject: | Re: How to modify ENUM datatypes? |
| Date: | 2008-04-23 21:51:48 |
| Message-ID: | 200804231751.48705.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 23 April 2008 14:10, Karsten Hilbert wrote:
> On Wed, Apr 23, 2008 at 12:38:48PM +0200, Andreas 'ads' Scherbaum wrote:
> > Yes. You should/can use ENUM for something like 'gender':
> > male, female, unknown. You don't need to add other values ever (yeah, i
> > skipped some special cases).
>
> I was gonna say ! :-)
>
> Add
>
> hermaphrodite
> transgender with female phenotype
> transgender with male phenotype
>
> and you should be set from current medical science's point
> of view ;-)
>
The standard is unknown, male, female, and n/a.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Wultsch | 2008-04-23 21:56:24 | Re: How to modify ENUM datatypes? |
| Previous Message | Tom Allison | 2008-04-23 21:35:14 | Re: Need to update all my 60 million rows at once without transactional integrity |