Hi
Is it possible to do a JOIN between a VIEW and the output of a FUNCTION?
e.g.
I have a function returning a SETOF records (using OUT parameters) with the
following output:
testdb=# SELECT * FROM myfunc( 'AAA1' ); -- returns calculcated values for all
orders for account 'AAA1'
_acc |
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of gmb
Sent: Friday, April 08, 2011 6:57 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Using Function returning setof record in JOIN
Hi
Is it possible to do a JOIN between a VIEW and the output of a FUNCTION?
e.g.
I have a function
On Fri, Apr 8, 2011 at 5:57 AM, gmb gmbou...@gmail.com wrote:
Hi
Is it possible to do a JOIN between a VIEW and the output of a FUNCTION?
yes.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
2011/4/8 Merlin Moncure mmonc...@gmail.com:
On Fri, Apr 8, 2011 at 5:57 AM, gmb gmbou...@gmail.com wrote:
Hi
Is it possible to do a JOIN between a VIEW and the output of a FUNCTION?
yes.
yes, it is possible. Just I am not sure if original query wasn't
directed to lateral feature.
Pavel