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@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 - 16:53:04 CDT