Data cube in PostgreSQL

Hi All,

I need to make certain changes to cube.c file which comes with cube contrib
( http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/). I am not
sure how to compile it so that I can use those changes in postgresql. Could
you help me?

Thanks
Gowrishankar L

On 10/19/07, Gowrishankar L <gowrishankar83(at)gmail(dot)com> wrote:
>
> Hi,
>
> I am using cube contrib from http://developer. postgresql
> .org/cvsweb.cgi/pgsql/contrib/cube/<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(at)hi-media(dot)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
> >
>
>