Re: Calculating Minkowski distance between two rows

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Calculating Minkowski distance between two rows
Дата
Msg-id CA+bJJbxvkRuK-jdgO6aB3xSncSY_QVRUL0CYe3-=-qfGc8B3hA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Calculating Minkowski distance between two rows  (Babak Alipour <babak.alipour@gmail.com>)
Ответы Re: Calculating Minkowski distance between two rows  (Begin Daniel <jfd553@hotmail.com>)
Список pgsql-general
Hi:

On Mon, Apr 25, 2016 at 4:26 PM, Babak Alipour <babak.alipour@gmail.com> wrote:
> That is correct. The function I've written only works when the two tables
> are named table_train and table_test; is it possible to generalize that to
> take in any two tables?

And only when all table_train columns are numbers AND table_test
contains at least all of them AND they are numbers too.

Wouldn't it be easier to use numeric arrays to represent coordinate vectors?

Anyway, I'm not versed in all of this, wbut I would try to make a
function to turn a table record to a numeric array and then write the
numeric array version of the func and call them, divide and conquer.

Francisco Olarte.


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Calculating Minkowski distance between two rows
Следующее
От: "Wetzel, Juergen (Juergen)"
Дата:
Сообщение: Intemittendly get "server process (PID 5884) exited with exit code 3"