Have several 128 elements lists, need to obtain distance between them

3 votes

1 answer

673 views

postgresql array python postgresql-10 cube

                          Is storing them in a [CUBE](https://www.postgresql.org/docs/current/static/cube.html)  type field and then getting euclidean distance, (using ``) the only way?

I can not save them as a list of floats, since i get: *"can't adapt type numpyndarray"*

Can not cast a type bytea to type cube, either.

Cube extension is installed, i can convert the list to type bytea using psycopg2, but nothing seems to work.

What am i missing?

I'm using postgresql 10.4, python 3, postgresapp 2.1.4 and postico

Asked by misterghost (41 rep)

May 22, 2018, 05:36 PM
Last activity: Nov 17, 2020, 01:02 AM

Have several 128 elements lists, need to obtain distance between them

Related Questions