Data cube in PostgreSQL - Mailing list pgsql-general

Hi,

I am using cube contrib from   http://developer. postgresql.org/cvsweb.cgi/pgsql/contrib/cube/

I am able to use most of the functions like cube_distance,cube_contains etc. I am facing a problem when passing an argument to these functions which are table columns.

For example :

 select cube_distance('(0)','(1)');

 cube_distance
---------------
             1
(1 row)

works fine.

But

select cube_distance('(0)',(select a from temp));

ERROR:  function cube_distance("unknown", integer) does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

I am not sure what to typecast to. Could you please help me correct this error.

Thanks
Gowrishankar L

On 10/1/07, Dimitri Fontaine < dfontaine@hi-media.com> wrote:

Hi,

Le Wednesday 26 September 2007 20:58:38 Gowrishankar, vous avez écrit:
> Is there any other way of extending postgresql to include cubes?

Something like the cube contrib?
   http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/

Contribs are part of PostgreSQL sources and maintained as such, but not
included into the 'core' project. They are certainly distributed along with
PostgreSQL in your packaging system of choice.

Regards,
--
dim