Raymond O'Donnell <rod@xxxxxx> schrieb: > 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))) What about with Hermaphroditism? SCNR. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
