Re: [Gnumed-devel] Demographics schema - urb postcode not null

[Sebastian Hilbert]

On Saturday 08 October 2011 10:57:04 Karsten Hilbert wrote:
> On Sat, Oct 08, 2011 at 08:16:36AM +0200, Hilbert, Sebastian wrote:
> > While I won't comment on nullable or not keep in mind that postcodes are
> > usefull for statistics and calculations (e.g. look up a distance or route
> > on google maps). BTW. How often do you input a postcode. Once ?
> > It will even be imported automatically most of the time.
> > 
> > I guess it would make sense to define unknown as value so this can be
> > searched for and updated later.
> 
> That's what Jim's arguing for re NULLable postcode.

I was under the impression that NULL can be different from unkown.

While being NULL it is not enforced uknown is something that can be enforced.

Sebastian