Kris Kiger <[EMAIL PROTECTED]> writes: > Interesting. That makes sense, though. So, is there a good way to lock > a set of rows using SELECT FOR UPDATE in plpgsql? I assume using > PERFORM would yield the same problem, because it immediately discards > the results.
I think PERFORM would work. The fact that plpgsql ignores the results doesn't mean you don't have lock on the rows. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq