On Tue, Oct 13, 2009 at 4:17 PM, Shaul Dar <shauldar(at)gmail(dot)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