DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:References:Mime-Version:In-Reply-To:X-Apple-Yahoo-Original-Message-Folder:Content-Type:Content-Transfer-Encoding:Message-Id:Cc:X-Mailer:From:X-Apple-Yahoo-Replied-Msgid:Subject:Date:To;
	b=AYgvqUS2cRpK56bgvgoXkjgJ35hCHLImXfI6A91AOkULsqCPUlh1ghoKpW8xuB2iBo8C9mzrk/pp+8cvFkgEGzlGdbubL3IbOtvu4MEetHyYHd8Nw1oar/reFhvSx1t95Z6XUOK7V7av+Y/Edmvjg9LV5fRirYco9/3vh5eHoc4=
	;
References: <4E8DEC80.3010706@gmail.com>
Mime-Version: 1.0 (iPad Mail 8J2)
In-Reply-To: <4E8DEC80.3010706@gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-1-479406219
Content-Transfer-Encoding: 7bit
Message-Id: <4852CB86-2376-4A88-9B60-255FD9CFCDC3@yahoo.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: David Johnston <polobo@yahoo.com>
Subject: Re: plpgsql function executed multiple times for each return value
Date: Sat, 8 Oct 2011 11:50:21 -0400
To: Steve Northamer <stevenorthamer@gmail.com>


--Apple-Mail-1-479406219
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii


> So my questions are:  1) How do we cause the paymentcalc function to be ex=
ecuted only once?  and 2) How do we call a table returning function with inp=
uts from a table?
>=20
> Thank you very much!
>=20
> Steve
>=20

WITH func AS (
   SELECT FUNC(...) AS func_result FROM ...
)
SELECT (func.func_result).* FROM func

David J.


--Apple-Mail-1-479406219
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=utf-8

<html><body bgcolor="#FFFFFF"><br><blockquote type="cite"><div><span>So my questions are: &nbsp;1) How do we cause the paymentcalc function to be executed only once? &nbsp;and 2) How do we call a table returning function with inputs from a table?</span><br><span></span><br><span>Thank you very much!</span><br><span></span><br><span>Steve</span><br><font class="Apple-style-span" color="#000000"><font class="Apple-style-span" color="#0023A3"><br></font></font></div></blockquote><div><br><div>WITH func AS (</div><div>&nbsp;&nbsp; SELECT FUNC(...) AS func_result FROM ...</div><div>)</div><div>SELECT (func.func_result).* FROM func</div><div><br></div><div>David J.</div><div><br></div><div><br></div></div></body></html>
--Apple-Mail-1-479406219--