sorry, i wrote the funciton wrong. here is what i meant to write:
CREATE OR REPLACE FUNCTION public.sample(varchar)
RETURNS SETOF record AS
'
DECLARE
row RECORD;
BEGIN
LOCK TABLE table1 IN ROW SHARE MODE;
FOR urlrow in EXECUTE \'SELECT * FROM table1\'
LOOP
UPDATE table1 SET col1=5 WHERE
will locks work inside functions or only in transactions?
will this lock?
CREATE OR REPLACE FUNCTION public.sample(varchar)
RETURNS SETOF record AS
'
DECLARE
row RECORD;
BEGIN
LOCK TABLE URL IN ROW SHARE MODE;
FOR urlrow in EXECUTE \'SELECT * FROM table1\'
LOOP
UPDATE table1 SET