Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jGo0j-0003dQ-Hx for pgsql-performance@arkaria.postgresql.org; Tue, 24 Mar 2020 18:10:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jGo0i-00074o-1L for pgsql-performance@arkaria.postgresql.org; Tue, 24 Mar 2020 18:10:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jGo0h-00074h-O9 for pgsql-performance@lists.postgresql.org; Tue, 24 Mar 2020 18:10:43 +0000 Received: from hm1481-39.locaweb.com.br ([189.126.112.77]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jGo0c-0006rh-Rz for pgsql-performance@lists.postgresql.org; Tue, 24 Mar 2020 18:10:43 +0000 Received: from mcbain0015.correio.biz (201.76.49.38) by hm1481.locaweb.com.br id hf96fe169v01 for ; Tue, 24 Mar 2020 15:09:48 -0300 (envelope-from ) Received: from proxy.email-ssl.com.br (bartf0020.email.locaweb.com.br [10.31.120.52]) by mcbain0015.correio.biz (Postfix) with ESMTP id C4F65400345 for ; Tue, 24 Mar 2020 15:10:13 -0300 (-03) x-locaweb-id: qyHzKK_R8aWhjwoIerpCUhsi5PfCUymhK53qXIAegdcRogeYX3-XTadcSpgGGxitWQf3rKGbFuqvLmn5XdJ_XeDnSC7FYZn7HbLXpGF-9IgCFmgQGgrxCDEo15F9LB44fLJFC6SgfN_fybCzqZ9P0DzPupXGAnaM3dEXV-naSc1N6bW5GIESynejzvtANJKkcLK6hZ70EHrgFVel71TRHpDrRUJqQqFISuEmrepFNvU= NmM3NTY5NzM3MjZmNjI2NTcyNzQ2ZjQwNzM2OTczNjM2ZjYyNzI2MTJlNjM2ZjZkMmU2Mjcy X-LocaWeb-COR: locaweb_2009_x-mail X-AuthUser: luisroberto@siscobra.com.br Received: from [172.16.16.4] (unknown [189.72.79.99]) (Authenticated sender: luisroberto@siscobra.com.br) by proxy.email-ssl.com.br (Postfix) with ESMTPSA id B51BD74059F for ; Tue, 24 Mar 2020 15:10:24 -0300 (-03) To: pgsql-performance@lists.postgresql.org From: Luis Roberto Weck Subject: Random function Message-ID: <95311e45-95e3-970b-e54f-3a4595d55dbb@siscobra.com.br> Date: Tue, 24 Mar 2020 15:10:16 -0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Thunderbird/68.6.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: pt-BR List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, I am trying to generate some random data using the random() function. However, I am getting the same result over mulitiple rows. This is a sample of the SQL I am using: select (select string_agg(random()::text,';')           from pg_catalog.generate_series(1,3,1) )   from generate_series(1,10,1) And I am getting something like: |string_agg | +--------------------------------------------------------------+ |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| |0.243969671428203583;0.692578794434666634;0.291524752043187618| If this is the expected output, is there a way to always generate random numbers?