Tom Lane <[EMAIL PROTECTED]> wrote:
> I assume though that this is a made-up example and is not the case
> that's really troubling you. What is the actual problem you are looking
> at?
I was generating random test data and naively assumed that ()::integer
truncated its value, therefore I was gett
David Newall <[EMAIL PROTECTED]> writes:
> NOW CONSIDER the following query, executed using psql:
> SELECT i, j from (
> SELECT i, ((i + 18 * random())::integer % 20 + 1) AS j FROM data
> ) foo WHERE j = 15;
Hmph. Evidently the planner should refuse to flatten subselects that
have volatile fun
