Problem with volatile function
От | Artacus |
---|---|
Тема | Problem with volatile function |
Дата | |
Msg-id | 4859CE4E.5010501@comcast.net обсуждение исходный текст |
Ответы |
Re: Problem with volatile function
Re: Problem with volatile function Re: Problem with volatile function |
Список | pgsql-general |
So my understanding of volatile functions is that volatile functions can return different results given the same input. I have a function random(int, int) that returns a random value between $1 and $2. I want to use it in a query to generate values. But it only evaluates once per query and not once per row like I need it to. -- This always returns the same value SELECT ts.sis_id, bldg_id, f_name.name, l_name.name FROM tmp_students ts JOIN names AS f_name ON ts.gender = f_name.gender WHERE f_name.counter = random(1,300) --As does this SELECT ts.sis_id, bldg_id, f_name.name, l_name.name FROM tmp_students ts JOIN names AS f_name ON ts.gender = f_name.gender AND ts.counter = random(1,100) -- This generates different numbers SELECT random(1,100), s.* FROM usr_students s
В списке pgsql-general по дате отправления: