I have a problem that I don't know where to look to understand the problem.
I have a function that I first select to get a table name followed by another select into on that table name. If someone could tell me where to look to solve this problem I would appreciate it. It is something like DECLARE rec1 Record; rec2 Record; SELECT aName INTO rec1 FROM tableA WHERE new.xxx = ?; IF FOUND THEN SELECT * INTO rec2 FROM rec1.aName where new.xxx = ?; Thanks ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate