PL/pgSQL fejl
jeg får:ERROR during compile of cleanup_order near line 21
parse error at or near LOOP
når jeg prøver at køre den her:
CREATE FUNCTION cleanup_order(integer,integer)
RETURNS boolean
AS \'
DECLARE
p_id ALIAS FOR $1;
o_id ALIAS FOR $2;
cur_order_id integer;
cur_item_id integer;
BEGIN
FOR cur_order_id IN SELECT id FROM ordre WHERE person_id = p_id AND status = 1 AND id != o_id
LOOP
RAISE NOTICE \'\'outer: %\'\',cur_order_id;
FOR cur_item_id IN SELECT id FROM item WHERE order_id = cur_order_id
LOOP
RAISE NOTICE \'\'inner: %\'\',cur_item_id;
UPDATE item SET ordre_id = o_id WHERE id = cur_item_id;
END LOOP;
UPDATE ordre SET status = 0 WHERE id = cur_order_id;
END LOOP;
RETURN TRUE;
END;
\'
LANGUAGE \'plpgsql\';
hvoffer det?
