Raymond O'Donnell wrote:
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?
--
-- PostgreSQL database dump
--
CREATE TABLE gender (
gender_pk SERIAL,
gender character varying(9) NOT NULL
);
COMMENT ON TABLE gender IS 'This table defines currently valid gender
types (and allows for god knows what..).';
COPY gender (gender_pk, gender) FROM stdin;
0 (unknown)
1 Male
2 Female
3 Trans
\.
ALTER TABLE ONLY gender ADD CONSTRAINT gender_pkey PRIMARY KEY (gender_pk);
