Re: Getting a random row
| От | Grzegorz Jaśkiewicz |
|---|---|
| Тема | Re: Getting a random row |
| Дата | |
| Msg-id | 2f4958ff0910130819q22fd9cct25064ceddf128be7@mail.gmail.com обсуждение исходный текст |
| Ответ на | Getting a random row (Shaul Dar <shauldar@gmail.com>) |
| Ответы |
Re: Getting a random row
Re: Getting a random row |
| Список | pgsql-performance |
On Tue, Oct 13, 2009 at 4:17 PM, Shaul Dar <shauldar@gmail.com> wrote:
Hi,
I am running performance simulation against a DB. I want to randomly pull different records from a large table. However the table has no columns that hold sequential integer values (1..MAX), i.e. the columns all have "holes" (due to earlier filtering).
what do yo umean ? you can restrict range of integer column (or any other type) with constraints, for instance CHECK foo( a between 1 and 100);
Also PG does not have a concept of an auto-increment pseudo-column like Oracle's "rownum". Any suggestions?
not true - it has sequences, and pseudo type serial. Rtfm!.
--
GJ
В списке pgsql-performance по дате отправления: