cube problem - Mailing list pgsql-general

From ABHANG RANE
Subject cube problem
Date
Msg-id 20070607204812.ms0e8z0pq8wso4k0@webmail.iu.edu
Whole thread Raw
Responses Re: cube problem  ("Alexander Staubo" <alex@purefiction.net>)
List pgsql-general
Hi,
I have a table with one column as real[]. Now if I want to make cubes
out of each of
these arrays, is there a way in postgre I can do it. I guess cube
operator is not defined
for real[] but can I create cubes if the column was integer[]. If yes
please may I know
how.

Actually I would pass an real[] array to a function. I want to create a
cube out of this
so that, somehow I can calculate the distance between this cube and
each row in the table
which has a column of real[]. So I would have to create a cube for each
row in the table.
I can write a function which accepts array and calculate such distance
in C but thats too
slow since there are 10 million rows.

Thanks
Abhang


pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Creditcard Number Security was Re: Encrypted column
Next
From: "George Pavlov"
Date:
Subject: Re: query log corrupted-looking entries