I knew I was forgetting something in the HOWTO. Can I use this example there?
For the record, the reason why SELECT INTO does not work with EXECUTE is because when the query is passed to the executor, it knows nothing about the PL/PgSQL function. It's just another query, so it can't return the value to a variable by itself (unless you do something like Dan suggests).
