Re: pg_sample - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: pg_sample
Date
Msg-id 20161019093245.rhnduhwxsq6v6zk4@hermes.hilbert.loc
Whole thread Raw
In response to pg_sample  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On Wed, Oct 19, 2016 at 01:24:10PM +1300, Patrick B wrote:

> I'm using pg_sample to do that, but unfortunately it doesn't work well.
> It doesn't get the first 100 rows. It gets random 100 rows.
>
> Do you guys have any idea how could I do this?

For any relevant answer to this question you'll have to
define what "first" means in the context of "first 100 rows".

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Getting the currently used sequence for a SERIAL column
Next
From: "Alex Ignatov \(postgrespro\)"
Date:
Subject: Drop user cascade