Re: View challenge
Date: 12 Aug 2006 05:12:06 -0700
Message-ID: <1155384726.620271.253800_at_p79g2000cwp.googlegroups.com>
> Well, that's not a view. See those tuples with values
> like 2006-08-14 and 2006-08-15? Those values don't
> appear in your tuples; you need something to generate
> those.
The values a view returns doesn't need to appear in the base tables.
They may be calculated. The formula would be something like this:
starttime + i*recur_interval
> sometimes the difference involves applying arithmetic
> functions or aggregators to data and supplying values
> that are not directly represented in the data. But
> you seem to be asking for something different here.
No, it is a simple arithmetic expression.
> mechanism that looks like a table but behaves like a
> function is called a table function and in postgres
> they're just called functions.
Obviously it would be no problem solving it, if the DBMS supports views
that are backed up by a stored procedure.
> make some data. The difficulty is that databases
> store data and can present it in different forms.
> If you require something other than what the database
> provides, you'll have to write it, and it isn't a view.
A RDBMS is capable of rather complex calculations.
/Fredrik