Re: Statistics with PostgreSQL

/* On the test stub: */
[snip]
double           data[30];
int             main(void)
{
    size_t          i;
    size_t          size = sizeof(data) / sizeof(data[0]);
    for (i = 0; i < size; i++) {
        data[i] = rand();
    }


    for (i = 0; i < size; i++) {
        cout << data[i] << endl;
    }

    cout << "1st item is " << RandomSelect(data, 0, size - 1, 0) <<
endl;
    cout << "2nd item is " << RandomSelect(data, 0, size - 1, 1) <<
endl;
    cout << "3rd item is " << RandomSelect(data, 0, size - 1, 2) <<
endl;
    for (i = 4; i < size; i++)
        cout  << i << "th item is " << RandomSelect(data, 0, size - 1,
i) << endl;
    return 0;
}

/*
The positions are cardinal, so the first three queries above should be:
    cout << "1st item is " << RandomSelect(data, 0, size - 1, 1) <<
endl;
    cout << "2nd item is " << RandomSelect(data, 0, size - 1, 2) <<
endl;
    cout << "3rd item is " << RandomSelect(data, 0, size - 1, 3) <<
endl;
*/