Eric Brown <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION g2(int) RETURNS int LANGUAGE plpgsql AS ' > DECLARE item t1%ROWTYPE; > BEGIN > SELECT INTO item * FROM t1 WHERE x = $1; > RETURN g1(item); > END';
This works in 8.0 but not earlier releases --- there was not support in plpgsql for using whole-row variables in expressions. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly