Message-ID: <512BAEA2.9040803@gmail.com>
Date: Mon, 25 Feb 2013 19:34:10 +0100
From: Surfing <onlinesurfing@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64;
	rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Euclidean distance between two sets of tuples
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Hi all,
     I would like to ask if there exists a function to calculate the 
Euclidean distance between two rows of the same table.
Obviously, the distance between two non-numeric fields should be 0 if 
they are the same value, 1 otherwise.

In general, I need to compute an average distance between the subsets of 
rows, computed pairwise.
Example:
- Set 1: 10 rows
- Set 2: 15 rows
- Distances computed 150
I just need the value 1/150*(Sum of all the computed Euclidean distances).

I could write a procedure, but it would be nice if there already exists 
a function which at least computes a single Euclidean function between 
two rows.

Any suggestion?

Thank you.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql