Re: Male/female
От | Andreas Kretschmer |
---|---|
Тема | Re: Male/female |
Дата | |
Msg-id | 20061208153542.GA24919@KanotixBox обсуждение исходный текст |
Ответ на | Male/female ("Raymond O'Donnell" <rod@iol.ie>) |
Ответы |
Re: Male/female
|
Список | pgsql-general |
Raymond O'Donnell <rod@iol.ie> 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°
В списке pgsql-general по дате отправления: