Re: On view updating
Date: 24 Sep 2004 17:34:37 -0700
Message-ID: <e4330f45.0409241634.3fb88d11_at_posting.google.com>
Costin Cozianu <c_cozianu_at_hotmail.com> wrote in message news:<2rintiF1arsdjU1_at_uni-berlin.de>...
> >>Oh, yes. A user can know that even trivially.
> >> SELECT OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_NAME='XXX'
> >
> > I am not talking about specific SQL DBMSs.
>
> But any RDBMS has to store metadata about its objects.
But nothing requires that the catalog must show to the users whether a variable is a base variable or a derived variable.
The DBA may be interested in hiding that information.
> >>typeof('XXX') => RelationType
> >>typeof('YYY') => REF RelationType
> >
> > Wrong, in a proper relational database the type of a view is a
> > relation type.
>
> That's complete bullshit.
That's completely evident. You don't have a clue on relational databases.
> You admitted you have no formal semantics, that is no mathematic and
> tons of handwaving, so discussion is closed.I should have known better.
Views are variables by definition and by prescription, it can't be discussed. What is bullshit is your irrelevant pap about semantics. Received on Sat Sep 25 2004 - 02:34:37 CEST