Hi all,
Can tables be joined with set returning functions? For example, it is
indeed possible to perform queries such as this:
SELECT oid, do_something (oid) FROM pg_class WHERE relkind = 'r';
Here, do_something returns only one record. What I'd like to do
instead is to select from a funct
;
spi_exec_query ($query);
return;
$$ LANGUAGE PLPERL;
However, I would rather use PL/PgSQL, since the Perl interpreter
might not be installed by default. Is there a way to access the NEW
record without knowing the field names in advance?
--
Best regards,
Tuukka Norri
---(end of broadcast)---
TIP 6: explain analyze is your friend
