Re: More on Database cells, and other terminology
From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Tue, 09 May 2006 13:28:53 -0400
Message-Id: <7407j3-sqi.ln1_at_pluto.downsfam.net>
>
> There is also a sort of column-level view concept in InterBase/Firebird.
> You can define a column and in place of the datatype you say "COMPUTED
> BY" and give an expression, which may reference other columns in the
> table. You can do the same thing in any individual query, but this
> virtual column is stored in the schema.
>
Date: Tue, 09 May 2006 13:28:53 -0400
Message-Id: <7407j3-sqi.ln1_at_pluto.downsfam.net>
Bill Karwin wrote:
> Bob Badour wrote:
>> More important is the ignorant assertion that the dbms cannot derive >> data, which is exactly what views do.
>
> There is also a sort of column-level view concept in InterBase/Firebird.
> You can define a column and in place of the datatype you say "COMPUTED
> BY" and give an expression, which may reference other columns in the
> table. You can do the same thing in any individual query, but this
> virtual column is stored in the schema.
>
Methinks SQL server has this as well. I remember looking at it and being unimpressed because the formula could not even reference other computed values.
-- Kenneth Downs Secure Data Software, Inc. (Ken)nneth_at_(Sec)ure(Dat)a(.com)Received on Tue May 09 2006 - 19:28:53 CEST