Re: [GENERAL] cube operations

2007-05-17 Thread ABHANG RANE
Hi, But now having 12 columns and multicolumn index, wont this slow down the search process. I mean in general retrieving 12 columns using a multicolumn index is slower or faster compared to an index on a 12 size array? Thanks Abhang Quoting "John D. Burger" <[EMAIL PROTECTED]>: ABHANG RANE

Re: [GENERAL] cube operations

2007-05-16 Thread Oleg Bartunov
hacking contrib/intarray could help you. You need to add function which return the number of overlapped elements. Oleg On Wed, 16 May 2007, John D. Burger wrote: ABHANG RANE wrote: I have a array column which has 12 real values in it. Basically these values represent co-ordinates in 12 dimen

Re: [GENERAL] cube operations

2007-05-16 Thread John D. Burger
ABHANG RANE wrote: I have a array column which has 12 real values in it. Basically these values represent co-ordinates in 12 dimensions for a substance. My main need is to find substances similar to a particular compound. Now I can do by calculating differences with each array in the whol

Re: [GENERAL] cube operations

2007-05-16 Thread Filip RembiaƂkowski
2007/5/16, ABHANG RANE <[EMAIL PROTECTED]>: Hi, I have a array column which has 12 real values in it. Basically these values represent co-ordinates in 12 dimensions for a substance. My main need is to find substances similar to a particular compound. Now I can do by calculating differences with e

[GENERAL] cube operations

2007-05-16 Thread ABHANG RANE
Hi, I have a array column which has 12 real values in it. Basically these values represent co-ordinates in 12 dimensions for a substance. My main need is to find substances similar to a particular compound. Now I can do by calculating differences with each array in the whole table. But the tab