CREATE FUNCTION is_parent(INTEGER, INTEGER) RETURNS BOOLEAN AS '
DECLARE
parent ALIAS FOR $1;
tull ALIAS for $2;
kid INTEGER;
BEGIN
kid := tull;
LOOP
SELECT INTO kid "dir-id" FROM dir WHERE id = kid;
IF kid = parent THEN
RETURN TRUE;
END IF;
IF kid IS NULL THEN
RETURN FALSE;
END IF;
END LOOP;
END;
' LANGUAGE 'plpgsql';
Will cause the following compilation error:
NOTICE: plpgsql: ERROR during compile of is_parent near line 8
ERROR: unterminated "
If I change the column name to dir_id it works fine.
It does not matter whether or not I use quotes.
Aasmund Midttun Godal
aasmund(at)godal(dot)com - http://www.godal.com/
+47 40 45 20 46