Postgres Pro
Downloads
Home   >   mailing lists

random query - Mailing list pgsql-sql

From Oleg Bartunov
Subject random query
Date
Msg-id Pine.GSO.3.96.SK.991030002713.21751n-100000@ra
Whole thread Raw
Responses Re: [SQL] random query  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-sql
Tree view 
I need to get random value:

select random(id) from messages where .....
Is't possible with SQL ?
Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] trivial problem
Next
From: Werner Reisberger
Date:
Subject: tuning large selects