Re: A Simple web application

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A Simple web application
Date: 2014-01-27 15:49:36
Message-ID: BLU0-SMTP435118AF43031CD89AD53BBCFA20@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-01-27 15:58:31 Re: A Simple web application
Previous Message ZHIBIN NIU 2014-01-27 15:40:45 Can not add thirty-party libraries into PostgreSQl source code under eclipse.