Received: from localhost (pluto.hub.org [200.46.204.4])
	by postgresql.org (Postfix) with ESMTP id 0651B9F93C9
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 16:31:16 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024)
	with ESMTP id 95014-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 16 Nov 2006 16:30:58 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170])
	by postgresql.org (Postfix) with ESMTP id 9FAAB9F9D99
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 16:31:11 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so472505ugf
	for <pgsql-sql@postgresql.org>; Thu, 16 Nov 2006 12:31:09 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=gtPkMceNF/BY1vElr///e32XU9GPBb4awEOHbVaV/HDfmJZ1NbLrw6qSoq9LnrY7SK2h87fK2MM3on2ipuIOLJDQWhrwi7qABkmI73q1MaWuPLuHolbgOAmsPmpv5KEDloZEwnL18wYsHZ91kvBStjMaD7X7XrU0NRLErrMBx9U=
Received: by 10.67.20.3 with SMTP id x3mr924025ugi.1163709068921;
	Thu, 16 Nov 2006 12:31:08 -0800 (PST)
Received: by 10.67.118.11 with HTTP; Thu, 16 Nov 2006 12:31:08 -0800 (PST)
Message-ID: <55c095e90611161231h64a3478ua1308af663539b04@mail.gmail.com>
Date: Thu, 16 Nov 2006 18:31:08 -0200
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Subject: Re: Random()
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20061116191632.GA21285@a-kretschmer.de>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_31461_9506510.1163709068829"
References: <55c095e90611161031h7a1ce42chd9a59a53ba7e7028@mail.gmail.com>
	<20061116191632.GA21285@a-kretschmer.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/173
X-Sequence-Number: 26825

------=_Part_31461_9506510.1163709068829
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thank you so much andreas.

Regards
http://ezequiasrocha.blogspot.com

2006/11/16, A. Kretschmer <andreas.kretschmer@schollglas.com>:
>
> am  Thu, dem 16.11.2006, um 16:31:14 -0200 mailte Ezequias Rodrigues da
> Rocha folgendes:
> > Hi list,
> >
> > I have a bigint collumn and I would like to generate a random number
> within the
> > numbers of my column.
>
> select <bigint_column> from <your_table> order by random() limit 1;
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>



--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

------=_Part_31461_9506510.1163709068829
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thank you so much andreas.<br><br>Regards<br><a href=3D"http://ezequiasroch=
a.blogspot.com">http://ezequiasrocha.blogspot.com</a><br><br><div><span cla=
ss=3D"gmail_quote">2006/11/16, A. Kretschmer &lt;<a href=3D"mailto:andreas.=
kretschmer@schollglas.com">
andreas.kretschmer@schollglas.com</a>&gt;:</span><blockquote class=3D"gmail=
_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt=
 0pt 0.8ex; padding-left: 1ex;">am&nbsp;&nbsp;Thu, dem 16.11.2006, um 16:31=
:14 -0200 mailte Ezequias Rodrigues da Rocha folgendes:
<br>&gt; Hi list,<br>&gt;<br>&gt; I have a bigint collumn and I would like =
to generate a random number within the<br>&gt; numbers of my column.<br><br=
>select &lt;bigint_column&gt; from &lt;your_table&gt; order by random() lim=
it 1;
<br><br><br>Andreas<br>--<br>Andreas Kretschmer<br>Kontakt:&nbsp;&nbsp;Heyn=
itz: 035242/47215,&nbsp;&nbsp; D1: 0160/7141639 (mehr: -&gt; Header)<br>Gnu=
PG-ID:&nbsp;&nbsp; 0x3FFF606C, privat 0x7F4584DA&nbsp;&nbsp; <a href=3D"htt=
p://wwwkeys.de.pgp.net">http://wwwkeys.de.pgp.net
</a><br><br>---------------------------(end of broadcast)------------------=
---------<br>TIP 1: if posting/reading through Usenet, please send an appro=
priate<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; subscribe-nomail command to =
<a href=3D"mailto:majordomo@postgresql.org">
majordomo@postgresql.org</a> so that your<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp; message can get through to the mailing list cleanly<br></blockquote>=
</div><br><br clear=3D"all"><br>-- <br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Atenciosamente (S=
incerely)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;Ezequias Rodrigues da Rocha<br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-<br>A pior das democracias ainda =E9 melho=
r do que a melhor das ditaduras
<br>The worst of democracies is still better than the better of dictatorshi=
ps<br> <a href=3D"http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.=
blogspot.com/</a>

------=_Part_31461_9506510.1163709068829--