Given an update that uses CTEs like this:
WITH
lock_rows AS (
SELECT 1 FROM tbl WHERE [...] FOR UPDATE
)
UPDATE [...]
Will the rows in `tbl` remain locked until the UPDATE is finished?
Also, does it matter if `lock_rows` is referenced? (IIUC the query
wouldn't be run if the CTE isn't referenced if it was for a SELECT, but
since it's an UPDATE, it will be run anyway)
Thanks!
Seamus
--
Seamus Abshere, SCEA
https://github.com/seamusabshere
https://linkedin.com/in/seamusabshere
https://www.faraday.io