Re: [elephant-devel] Is it possible to query by 2 index ranges at the same time

2007-06-01 Thread lists
Hi Ian, I read the thread from a few days ago regarding OIDs. While I agree with your position, I think it's beneficial to be able to get a list of OIDs to be able to perform these kinds of operations. I think the premise from the other thread was that of "relying" on OIDs for relational purpos

Re: [elephant-devel] Is it possible to query by 2 index ranges at the same time

2007-05-31 Thread Ian Eslick
That's very insightful and quite correct! I was going to use this mechanism as part of the query system I want to get working for 1.0. This is pretty much the mechanism that relational databases use to do join queries and Elephant will be no different. As a matter of discipline, I didn't

Re: [elephant-devel] Is it possible to query by 2 index ranges at the same time

2007-05-31 Thread lists
Please excuse if I don't make a direct reference to Elephant solving this in my comment below. However, I remembered reading something just like this in AllegroCache's Reference Manual, in which it said, and I quote: "In a database every object has a unique object identifier (oid). This value c

Re: [elephant-devel] Is it possible to query by 2 index ranges at the same time

2007-05-31 Thread Ian Eslick
Ignas, The easiest way to do this is to follow Robert's suggestion, and declare slots x and y to be indexed (assuming your parameters are slot values of a persistent objects) and then say: (remove-duplicates (nconc (get-instances-by-range 'my-class 'x 10 20) (get-instances-by-ran

Re: [elephant-devel] Is it possible to query by 2 index ranges at the same time

2007-05-31 Thread Robert L. Read
I'm assuming x and y are properites of a data object, which has some other component z which you with to retrieve, and you query is that you want to find all the records (x,y,z) such that (10 < x < 20) and ( -5 < y < 15). There is a spectrum of solutions to this problem. However, in the general

[elephant-devel] Is it possible to query by 2 index ranges at the same time

2007-05-31 Thread Ignas Mikalajunas
Hi, i have an interesting usecase and i would like to ask whether i can solve it by using Elephant. I would like to index objects placed on a discreet 2d grid of an arbitarry size, which would require queries like (10 < x < 20) AND (-5 < y < 15). Is it possible to perform such a query with elep