Re: (domain support) Re: theory and practice: ying and yang

DM Unseen wrote:
> Paul,
>
> See Alfredo's link for more info in SQL Server(Thanks Alfredo!)
>
...

yes, thank you both. however, i don't see why one should have to buy into dotnot with all that it entails to do something that seems at least to me to be so basic.

> ...
> Your address type is interesting, buit gives even more issues than you
> might think. E.g. in my country a zipcode and housenumber already
> uniquely defines an adress, so I suspect in my situation an address UDT
> would be a borderline case. In my country I would just store the
> housenumber and zipcode, and this would allow me to easily define
> (in)equality and ordering as well.

i think zipcode in the USA is usually redundant at least in a strict sense, as is postal code here in canada, although most of the time we pretend that there is no functional dependency involved. not clear that inequality implies ordering but perhaps that's not what you meant. i was thinking of an address such as:

#109-100 Frobisher St., Toronto Ontario Canada

which to the postal system here is the same as

100 Frobisher St. #109, Toronto Ontario Canada

i'd want the domain support to accept either form, tell me they are "equal" and tell me that 100 Frobisher St. "comes after" 13 Oriole Drive if i'm walking north to south and vice versa if i'm walking south to north.

pc Received on Fri May 27 2005 - 17:23:58 CEST