Re: A Simple web application
От | Edson Richter |
---|---|
Тема | Re: A Simple web application |
Дата | |
Msg-id | BLU0-SMTP435118AF43031CD89AD53BBCFA20@phx.gbl обсуждение исходный текст |
Ответ на | Re: A Simple web application (Raymond O'Donnell <rod@iol.ie>) |
Список | pgsql-general |
Em 27/01/2014 13:19, Raymond O'Donnell escreveu: > On 27/01/2014 15:16, Edson Richter wrote: >> Em 27/01/2014 10:42, Andreas Kretschmer escreveu: >>> Raymond O'Donnell <rod@iol.ie> wrote: >>> >>>> On 27/01/2014 12:11, Manoj Soni wrote: >>>>> Name, Age and Sex >>>>> Which tutorial, may help me in this regard. >>>> I did a Google search on "tomcat netbeans postgresql tutorial" and >>>> turned up some likely-looking links.... should work for you too. :-) >>> Right, and as a hint: dont store the AGE of a person, store the >>> birthdate instead. >>> >>> >>> Andreas >> Another hint: don't store "sex" (do/don't do?), but "gender" (even >> better if tristate: male/female/not informed or "other"). >> I already had lots of trouble with customers asking me to adjust my >> systems to this new "situation", then I've to change systems and >> database... > +1 to this... there was a lengthy thread on this list some years ago on > this very subject, and it was an eye-opener to see the possibilities > that emerged. > > Ray. > > Yes - indeed, this is so complex, that my current mapping is a One-to-many mapping with a aux "gender" table - so each customer would add as many options as they want. Regards, Edson
В списке pgsql-general по дате отправления: