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 <r...@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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to