Well when I run random() I do get a different answer for each run so random
behaves as I would expect. I didn’t look that closely at your query with
random.
e.g.
SELECT random()
FROM generate_series(1,100);
Even if within the same row, the random numbers are different:
SELECT
Thanks for your time & advice Regina, I appreciate it.
I still can't get this to work as I think it should, so have included actual
SQL's to show what I'm doing, using ST_GeneratePoints() this time...
I create a db & add the postgis extension
Then create the two tables to test, inserting 3
Gotcha...
I'm glad it didn't really make sense to you either. That is sort of what I
thought might be happening.
Nice to know I'm not a totally lost cause!!!
That works perfectly,
Thanks heaps!!
On Sunday, November 19, 2023 at 11:09:34 AM GMT+13, Regina Obe
wrote:
I’m guessing
I’m guessing the reason why your example doesn’t work is because the planner is
doing some serious short-circuiting cause it sees two subselects that are using
no variables from the updated table.
I suspect this is a bug or some intentional stuff that makes no sense to me.
Cause I’m pretty