Re: null as part of key?

And they are usually *not* used in the address. This applies at least to the Netherlands, Belgium, Luxemburg, Germany and a lot of other countries.
In the Netherlands provinces are only used if a place occurs in two provinces, and of course that shouldn't be necessary because of the zip code.
Having worked for the EMEA headoffice of an US firm I know how difficult it is to explain to US citizens not every country use the same procedure. It once took me one hour to explain the zip code of a PO box is by design not the same as the zip code of the address in the Netherlands.

So this is -sorry to say so- the usual US prejudice that the rest of the world functions in the same way the US does. It doesn't, luckily not.

Regards,

Sybrand Bakker
Senior Oracle DBA

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:tt9ee91hs1em62_at_corp.supernews.com...
> Just about every country has some political division that functions as a
> state does in the US = they're just not called "states".
>
> "ed zappulla" <zappullae_at_rcn.com> wrote in message
> news:9r1eih$aiq$1_at_bob.news.rcn.net...
> > I see. What about this case
> >
> > country
> > state
> > city
> > some other cols
> >
> > pk = country, state, city
> >
> > Some contries don't have states; therefore it would be null for those
> > countries.
> >
> > does this make sense?
> >
> >
> >
> > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message
> > news:3bd42f49$0$237$ed9e5944_at_reading.news.pipex.net...
> > > No. Nor in any version. If you think carefully you will see that
> allowing
> > > this would be a nonsense.
> > >
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> > > "ed zappulla" <zappullae_at_rcn.com> wrote in message
> > > news:9r19h8$jhr$1_at_bob.news.rcn.net...
> > > > Can a column be null and part of a primary key? oracle 8.1.6
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Tue Oct 23 2001 - 06:14:13 CDT