Postgres Pro
Downloads
Home   >   mailing lists

random rows - Mailing list pgsql-sql

From Jie Liang
Subject random rows
Date
Msg-id Pine.BSF.4.10.10104261133340.77756-100000@tidal.ipinc.com
Whole thread Raw
In response to No JOINs in UPDATE ... FROM?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: random rows  (Joel Burton <jburton@scw.org>)
List pgsql-sql
Tree view 
How I can return random N rows from my select stmt?
like:
e.g. what my selectee is a set of 1000 rows, I want randomly
pickup 100 of 1000.


thanks.



Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: No JOINs in UPDATE ... FROM?
Next
From: "Joao Pedro M. F. Monoo"
Date:
Subject: Re: random rows