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 LOn 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
