Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4B30B9F9D99 for ; Thu, 16 Nov 2006 14:31:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 57949-03 for ; Thu, 16 Nov 2006 18:31:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id D51FC9F9998 for ; Thu, 16 Nov 2006 14:31:17 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so442865ugf for ; Thu, 16 Nov 2006 10:31:15 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=SZ4yeo9JzsiyTHep4QbvF+7Fkddtj2JT3oGgdVAd7eBzeFpSe3XZdZ5j+AMnOxBCu65uF3r0hI3F2JuHtPnwi/UxNS+sQMwcmplUrH54zJw3YAr5H81YvFgOGlxc6M3xLYjaf2hdQsM4/ZE0x40Nrbjx6bqogzxJIvMIwKLG6hk= Received: by 10.67.22.2 with SMTP id z2mr716208ugi.1163701874251; Thu, 16 Nov 2006 10:31:14 -0800 (PST) Received: by 10.67.118.11 with HTTP; Thu, 16 Nov 2006 10:31:14 -0800 (PST) Message-ID: <55c095e90611161031h7a1ce42chd9a59a53ba7e7028@mail.gmail.com> Date: Thu, 16 Nov 2006 16:31:14 -0200 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: Random() MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_28741_17209749.1163701874104" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/170 X-Sequence-Number: 26822 ------=_Part_28741_17209749.1163701874104 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list, I have a bigint collumn and I would like to generate a random number within the numbers of my column. Is it possible ? =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_28741_17209749.1163701874104 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list,

I have a bigint collumn and I would like to generate a rand= om number within the numbers of my column.

Is it possible ?

<= 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-
            = ;            &n= bsp;         Atenciosamente (S= incerely)
          &n= bsp;            = ; 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 melho= r do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorshi= ps
http://ezequiasrocha.= blogspot.com/ ------=_Part_28741_17209749.1163701874104--