Re: pg_sample

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_sample
Date: 2016-10-19 09:32:45
Message-ID: 20161019093245.rhnduhwxsq6v6zk4@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • pg_sample at 2016-10-19 00:24:10 from Patrick B

Browse pgsql-general by date

  From Date Subject
Next Message Alex Ignatov (postgrespro) 2016-10-19 10:26:41 Drop user cascade
Previous Message Thomas Kellerer 2016-10-19 09:28:28 Re: Getting the currently used sequence for a SERIAL column