[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: CAP Query Language: Proposition to query properties with multiple occurrences
>The query: "All VEVENTs accepted by user1 and user2"
>Could be written as follows:
> SELECT * FROM VEVENT
> USING ATTENDEE AS ATT1,
> ATTENDEE AS ATT2
> WHERE ATT1.PARTSTAT = 'ACCEPTED' AND ATT1 = 'user1@xxxxxxxxxxx' AND
> ATT2.PARTSTAT = 'ACCEPTED' AND ATT2 = 'user2@xxxxxxxxxxx'
Possibly. On a CS with a SQL backend, this would then translate into
joining with the ATTENDEE table twice. Might not be efficient, but it's
Bruce, is this something that your engine could reasonably handle?
|John Stracke |Principal Engineer |
|jstracke@xxxxxxxxxxxxxxxxxxxx |Incentive Systems, Inc. |
|http://www.incentivesystems.com|My opinions are my own. |
|We must be devious, cunning, inventive... too bad we're us.|