From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stefan Zauchenberger <stefan@ice-sys.com>
cc: pgsql-admin@postgresql.org
Subject: Re: Call Function from within Function - parent / dispatch
In-reply-to: <7B1A245D-F8DD-4AAB-8ACF-3C2C7F5A9563@ice-sys.com>
References: <7B1A245D-F8DD-4AAB-8ACF-3C2C7F5A9563@ice-sys.com>
Comments: In-reply-to Stefan Zauchenberger <stefan@ice-sys.com>
	message dated "Thu, 23 Aug 2018 08:52:17 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <16789.1535034152.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 23 Aug 2018 10:22:32 -0400
Message-ID: <16790.1535034152@sss.pgh.pa.us>
Precedence: bulk

Stefan Zauchenberger <stefan@ice-sys.com> writes:
> I am having a problem creating a parent function that calls different fu=
nctions within based on conditions. The functions within all take the exac=
t same arguments and return the same set type. This must be a simple mista=
ke on my part, but not sure of the fix.

If you're trying to pass a set result back up, the easiest way is to
use "RETURN QUERY SELECT * FROM child_function(...)".  Plain "RETURN"
only works for scalar results, and RETURN NEXT is for producing a
result-set one row at a time.

			regards, tom lane