On Thu, 16 Jun 2011, David Johnston wrote:
The only way to feed another relation into a function is to place the
function in the SELECT list. If you then want to expand the result of the
function call you alias the function result and then ".*" against it.
WITH feeder AS (
SELECT f(var) AS result FROM xtable WHERE ...
)
SELECT (feeder.result).*
FROM feeder
;
[snip]
Thanks, David, this worked perfectly! {thanks also to Pavel}
-Frank
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
