> -----Oorspronkelijk bericht-----
> Van: H.J. Sanders [mailto:hjs@rmax.nl]
> Verzonden: vrijdag 8 december 2006 16:33
> Aan: Raymond O'Donnell
> Onderwerp: RE: [GENERAL] Male/female
>
>
> Hi ray.
>
> We have done it with a integer whereby
>
> 0 = woman
> 1 = man
>
> also self-documenting :-)
>
> Henk Sanders
>
>
>
> > -----Oorspronkelijk bericht-----
> > Van: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org]Namens Raymond O'Donnell
> > Verzonden: vrijdag 8 december 2006 16:23
> > Aan: pgsql-general@postgresql.org
> > Onderwerp: [GENERAL] Male/female
> >
> >
> > Just wondering.....how do list member represent gender when storing
> > details of people in a database?
> >
> > I've done it two ways:
> >
> > * A bool column, with the understanding that true/false represents
> > one gender or the other.
> >
> > * Create a domain, something like:
> > CREATE DOMAIN gender_domain
> > AS character varying(7)
> > NOT NULL
> > CONSTRAINT gender_domain_check CHECK ((((VALUE)::text =
> > 'male'::text) OR ((VALUE)::text = 'Female'::text)))
> >
> > I personally prefer the second, as it's self-documenting...is there
> > any other/better way of doing it?
> >
> > --Ray.
> >
> >
> > ----------------------------------------------------------------------
> >
> > Raymond O'Donnell
> > Director of Music, Galway Cathedral, Galway, Ireland
> > rod@iol.ie
> > ----------------------------------------------------------------------
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >