The following bug has been logged online: Bug reference: 1481 Logged by: alagu madhu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Redhat Description: ERROR: type tablename does not exist Details:
CREATE FUNCTION merge_fields(t_row tablename) RETURNS text AS $$ DECLARE t2_row table2name%ROWTYPE; BEGIN SELECT * INTO t2_row FROM table2name WHERE ... ; RETURN t_row.f1 || t2_row.f3 || t_row.f5 || t2_row.f7; END; $$ LANGUAGE plpgsql; ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster