Re: [PERFORM] Precomputed constants?

[Volkan YAZICI]

On Jun 14 12:53, Böszörményi Zoltán wrote:
> # explain analyze select * from mxstrpartsbg where szam =
> round(800000*random())::integer;

AFAIK, you can use sth like that:

SELECT * FROM mxstrpartsbg
  WHERE szam = (SELECT round(800000*random())::integer OFFSET 0);

This will prevent calculation of round() for every row.


Regards.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend