Search Postgresql Archives

Data cube in PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
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@xxxxxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux