Is there an easy and efficient way to return a boolean false for a query that returns no result, and true for one that does return a result?
Presuming that you're not using the values in temp_table, I think you should be using PERFORM * WHERE ...; and then IF FOUND ... ELSE ... END IF;
See here:
http://www.postgresql.org/docs/8.3/static/plpgsql-statements.html
and also follow link to 38.5.5 .
-Reece
