Hi,
I want to do a select in dynamic command, something like:
TRIGGER FUNCTION
DECLARE
table_name_suffix text;
temp_result RECORD;
temp_result2 RECORD;
....
BEGIN
--initialization of table_name_suffix(from TG_RELNAME e.g.)
select into temp_result from
''fixed_table_name_prefix''||table_name_suffix where another_table_name =
abc;
--Then I want to use part of the result as part of the table name for my
next query
select into temp_result2 from
''fixed_table_name_prefix''||temp_result.anotherta blename;
END
I know that SELECT INTO doesn't support dynamic command, EXECUTE does. But
if I EXECUTE a select query, how do I get
the select result from it?
Many thanks,
Wei Wang
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match