Is it possible to find out what value random returns in a request?

Question

PostgreSQL

Is there any way to find out what value random() returns in a request?
For example, a simple query: For example, random () will return 0.7678943212 and the query will actually look like this: is it possible to find out this number? Maybe somewhere in the logs is highlighted?
SELECT * FROM items WHERE id >= 1000*random()
SELECT * FROM items WHERE id >= 1000*0.7678943212

Answer 1

SELECT *, rnd FROM items, (SELECT random() AS rnd) AS r WHERE id >= 1000*rnd