Re: globals besides relvars?
Date: Mon, 28 Jul 2003 18:57:54 +0100
"Marshall Spight" <mspight_at_dnai.com> wrote in message
> For many things, a functional expression is better than the relational
> equivalent. For example, I'd rather invoke the getTimeZone() function
> Select * from TimeZone
> unwrap relation into tuple
> unwrap tuple into value
Marshall, you are arguing about syntax, but..
..claim to be interested in the logical model.
Syntax is mostly unimportant when at the logical level.
Yes. Queries and Updates.
> I'm groping my way towards a model where the concept of a
> programming language's global variables
The database is the only global variable. In fact it is the only varable *at all*.
If you do still want to talk about 'functions' that can access the global variable, then SQL table functions could be the place to start. They do things that you can't do with views, and their functionally is required in any good dbms IMO, but to my way of thinking, they are little more than macro expressions. Does suggest again that we need a better handle on how macros fit into things though.
Business Intelligence, IBM Global Services Received on Mon Jul 28 2003 - 19:57:54 CEST