Re: [HACKERS] Invalid optimization of VOLATILE function in WHERE clause?

[Kevin Grittner]

"Kevin Grittner" <kevin.gritt...@wicourts.gov> wrote:
> There is a workaround, if you don't mind ugly:
 
Or, better:
 
WITH source AS (
    SELECT i, random() AS r FROM generate_series(1,10) AS i
)
SELECT
    i
FROM
    source, (
        SELECT
            count(*) AS _n
        FROM source
    ) AS _stats
WHERE
    r < 5::DOUBLE PRECISION/_n;
 
-Kevin


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers