how to identify outliers - Mailing list pgsql-general

From Rhys A.D. Stewart
Subject how to identify outliers
Date
Msg-id 189966030910271436v4390fa34n77831932adbdd928@mail.gmail.com
Whole thread Raw
Responses Re: how to identify outliers
List pgsql-general
Hey all,
I have the following table:  data(pnum text, distance float8, route text).
I would like to remove the outliers in distance, i.e. lets say i get
the avg dist of pnum for each route and the std deviation of the
distance what is the best way to identify the outliers?


Rhys.

pgsql-general by date:

Previous
From: "Little, Douglas"
Date:
Subject: Re: Pgadmin support for writing files or psql \copy command
Next
From: fox7
Date:
Subject: Slow running query with views...how to increase efficiency? with index?