Rory Campbell-Lange <r...@campbell-lange.net> writes: > I'm doing an UPDATE something like this: > UPDATE > slots > SET > a = 'a' > ,b = (SELECT uuid_generate_v1()) > WHERE > c = TRUE;
> Each updated row in slots is getting the same value for b. That's Postgres' interpretation of an uncorrelated sub-SELECT: there's no reason to do it more than once, so it doesn't. > Is there a way of getting a per-row value from uuid_generate_v1() > without doing a PL loop? Drop the word "SELECT". Why did you put that in in the first place? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general