From: | Anderson Antunes <anderson(dot)ant(dot)oli(at)gmail(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16628: Hostame and string connection functions |
Date: | 2023-04-28 19:59:44 |
Message-ID: | CAAHHTi_yGdgwvcLFtU7rrjd9-PSghvSk6_RYSOW3uMujSLpuLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I'll look. Thanks.
Em sex., 28 de abr. de 2023 às 15:47, Bruce Momjian <bruce(at)momjian(dot)us>
escreveu:
> On Sat, Apr 22, 2023 at 11:57:06AM -0300, Anderson Antunes wrote:
> > I'm sorry for not responding earlier. She ended up falling into spam. I
> solved
> > it by creating a specific variable in the postgresql configuration file.
> >
> > If it's not too much trouble, I have another question: my name is
> Anderson
> > Antunes. I live in Brazil. I'm doing research for a master's project
> about
> > pseudo random numbers and would like to know more information about the
> random
> > () function used to randomly order a set of records. I tried to search
> through
> > the site that offers the source code but I couldn't identify the exact
> > implementation of this function.
>
> Looks like random() internally is called drandom():
>
> \x
> \df+ random
> List of functions
> -[ RECORD 1 ]-------+-----------------
> Schema | pg_catalog
> Name | random
> Result data type | double precision
> Argument data types |
> Type | func
> Volatility | volatile
> Parallel | restricted
> Owner | postgres
> Security | invoker
> Access privileges |
> Language | internal
> --> Internal name | drandom
> Description | random value
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
> EDB https://enterprisedb.com
>
> Embrace your flaws. They make you human, rather than perfect,
> which you will never be.
>
--
Atenciosamente,
Anderson Antunes
Bento Gonçalves
(53) 9142-2910
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2023-04-28 23:42:31 | Re: pg_basebackup: errors on macOS on directories with ".DS_Store" files |
Previous Message | Bruce Momjian | 2023-04-28 19:21:31 | Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type |