Re: pg_sample

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: pg_sample
Дата
Msg-id 20161019093245.rhnduhwxsq6v6zk4@hermes.hilbert.loc
обсуждение исходный текст
Ответ на pg_sample  (Patrick B <patrickbakerbr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Getting the currently used sequence for a SERIAL column
Следующее
От: "Alex Ignatov \(postgrespro\)"
Дата:
Сообщение: Drop user cascade