Steve Heaven wrote:
>
> At 20:18 24/07/00 -0400, you wrote:
> >Sigh, forgot to mention the solution. There's an undocumented function:
> >
> > * bool oidrand (oid o, int4 X)-
> > * takes in an oid and a int4 X, and will return 'true'
> > * about 1/X of the time.
> >
> >typically used l
Sent: Monday, July 24, 2000 12:20 PM
Subject: [GENERAL] Statistical Analysis
> I am having to perform a large data analysis query fairly frequently and
the
> execution time is not exceptable, so I was looking at doing a statictical
> sample of the data to get fairly accurate results. Is there
ent: Monday, July 24, 2000 3:20 PM
Subject: [GENERAL] Statistical Analysis
> I am having to perform a large data analysis query fairly frequently and
the
> execution time is not exceptable, so I was looking at doing a statictical
> sample of the data to get fairly accurate results. Is
I am having to perform a large data analysis query fairly frequently and the
execution time is not exceptable, so I was looking at doing a statictical
sample of the data to get fairly accurate results. Is there a way to
perform a query on a set number of random rows instead of the whole dataset?