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>
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=leandroReceived on Sun Jun 08 2003 - 23:26:52 CEST