Re: SQL virtual schema psudo proposal

[Doug Royer <Doug@xxxxxxxxx>]

Alan Davies wrote:
> 
> At 02:01 PM 11/01/2002 -0700, Doug Royer wrote:
> > > Er...then it will be impossible to make the query "get all events on this
> > > day", because the DTSTART and DTEND properties are in separate virtual
> > > tables.  No?
> >
> >As in 'they can be viewed' in separate virtual tables.
> >
> >So,
> >
> >         SELECT * FROM VEVENT WHERE VEVENT.DTSTART ...
> >                              AND VEVENT.DTEND ...
> >                              ...
> >
> >Would work, because to the VEVENT table, DTSTART and DTEND are
> >columns in the virtual VEVENT table (with their values).
> 
> That's a simple case: How would the parameters on the
> properties of a VEVENT's VALARM appear in the virtual
> VEVENT table?

As if the property was a simple virtual table. Again SQL-MIN
is NOT a full blown query language. It is the minimum set
of what it would take to get a CUA to work based on
the cap-requirements.

Trigger time only properties.

	SELECT TRIGGER FROM VALARM WHERE VALARM.TRIGGER ...

Then parse any paramaters in the CUA.

begin:vcard 
n:Royer;Doug
tel;cell:208-520-4044
tel;fax:208-552-1179
tel;work:208-520-4044
x-mozilla-html:FALSE
url:http://Royer.com/People/Doug
org:INET-Consulting LLC <http://INET-Consulting.com
adr:;;1795 W. Broadway #266;Idaho Falls;ID;83402;
version:2.1
email;internet:Doug@xxxxxxxxx
title:Chief Executive Manager
x-mozilla-cpt:;9152
fn:Doug Royer
end:vcard