Re: Normalisation

From: Jan Hidders <>
Date: Thu, 07 Jul 2005 18:33:08 GMT
Message-ID: <Ezeze.139544$>

Jon Heggland wrote:
> In article <AyVye.138732$>,
> says...

>>>>Note btw. that if user-defined functions are restricted to the 
>>>>domains (their input and output types are only domains) then you cannot 
>>>>define such an operation as a user-defined function.
>>>Let me try to define such an operator.
>>>unnest_string takes a relation IN and an attribute name A as arguments, 
>>>returns a relation OUT. The type of attribute A in IN is character 
>>Ah, but now you are using the domain or relations, right? There is a 
>>problem with that domain. It doesn't exist. The collection of all 
>>relations is a proper class, and not a set, but domains have to be sets.

> You'll have to educate me on the difference between "proper class" and
> "domain", I'm afraid. The term "class" is used for so many slightly
> different things.

> Should I be forbidden from treating "relation" as a (generic) domain
> when defining this operator? Why?

Because by definition it isn't, and redefining the notion of domain such that it is, is not that easy without either running into paradoxes or getting a notion which it is almost impossible to reason about.

> Would you allow this operator if it were system-defined?

I am not disallowing anything.

  • Jan Hidders
Received on Thu Jul 07 2005 - 20:33:08 CEST

Original text of this message