Re: Impossible Database Design?
From: Jay Dee <ais01479_at_aeneas.net>
Date: Thu, 18 May 2006 21:53:04 GMT
Message-ID: <416bg.40678$P2.3187_at_tornado.ohiordc.rr.com>
>
> I'll definitely have a closer look again!!
>
>
> I want to see the thing ;)
Date: Thu, 18 May 2006 21:53:04 GMT
Message-ID: <416bg.40678$P2.3187_at_tornado.ohiordc.rr.com>
Nikolai Onken wrote:
> Jay Dee wrote:
>
>>I've done this. Some of my other responses hinted at the approach >>I used.
>
> I'll definitely have a closer look again!!
>
>>The thing that spewed data >>looked like a table, but it wasn't.
>
> I want to see the thing ;)
It's not magic. In Postgres: a function. In Oracle: a table function. In RM: a read-only operator which returns a value of type relation. Use 'em in SQL queries like
select <what_i_want_to_see>
from not_magic
where not_magic.date between <from_now> and <until_then>
Received on Thu May 18 2006 - 23:53:04 CEST