Re: domains aren't subtypes, right?

From: Leandro Guimarães Faria Corsetti Dutra <lgcdutra_at_terra.com.br>
Date: Sun, 08 Jun 2003 23:26:52 +0200
Message-ID: <pan.2003.06.08.21.26.49.852786_at_terra.com.br>


On Wed, 04 Jun 2003 09:58:35 -0700, Mikito Harakiri wrote:

> Proposition. The only date type allowed stored in the RDBMS should be
> INSTANCE/TIMESTAMP
>
> Other datatypes are functions:
>
> DATE = FLOOR(TIMESTAMP / Day)
> TIME = TIMESTAMP (mod) Day

        Simple answer: why stored types have to be the same as represented ones?

-- 
 _
/ \  Leandro Guimarães Faria Corsetti Dutra     +41 (21) 648 11 34
\ /  http://br.geocities.com./lgcdutra/         +41 (78) 778 11 34
/ \  Responda à lista, não a mim diretamente!   +55 (11) 5686 2219
Rate this post if helpful: http://svcs.affero.net/rm.php?r=leandro
Received on Sun Jun 08 2003 - 23:26:52 CEST

Original text of this message