Re: domains aren't subtypes, right?

On Tue, 27 May 2003 18:05:57 +0000, Mikito Harakiri wrote:

> Surprisingly, they have a single Date datatype. And a single Number
> datatype. What a blessing!

        You sure could explain that better. I find Oracle's DATE confusing and frustrating, being period, date and timestamp all roled in one.

> Until recently. Clearly, they gave up to MS pressure, as the latter has
> native numbers and, therefore, better performance. Now, we are going to see
> Numeric Casts all over the place! I don't know who influenced polluting
> their datatype system with yet another timestamp type. ANSI SQL?

        What's the problem with ANSI SQL's time-related types?

> In short: having more datatypes is not an answer. Having better datatypes is
> the answer.

        And how Oracle's date is better?

-- 
Leandro Guimarães Faria Corsetti Dutra