[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: SQL virtual schema psudo proposal
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.
> > 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
Trigger time only properties.
SELECT TRIGGER FROM VALARM WHERE VALARM.TRIGGER ...
Then parse any paramaters in the CUA.
org:INET-Consulting LLC <http://INET-Consulting.com
adr:;;1795 W. Broadway #266;Idaho Falls;ID;83402;
title:Chief Executive Manager