DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=h+Tq2uVXIRpJ3hWAWLfnCrPnKLpmsjL91KlAOfisCN/X+f5lRg5PeYxplvz3WWsVf2
	hzWOpcGMCaMbBk8C9tqz5Xm2+SZ69MDOzb7nycvq2IYtJdtBdYerJKSsbvSYEPo0ekWK
	s4pvtnrDsmtPDJma5zDdgAHV/PyxFndSRfBvg=
MIME-Version: 1.0
In-Reply-To: <4ADAA720.3050706@gmail.com>
References: <302670f20910161927h688e13e7qd096e63e68b7ae6c@mail.gmail.com>
	<4AD93837.7030500@gmail.com> <hbc9qk$vc4$1@news.hub.org>
	<4ADAA720.3050706@gmail.com>
Date: Mon, 19 Oct 2009 17:54:13 -0400
Message-ID: <302670f20910191454r4faef8f7m78b5218e6e6a5788@mail.gmail.com>
Subject: Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL
	Function
From: Gary Chambers <gwchamb@gmail.com>
To: Rob Sargent <robjsargent@gmail.com>
Cc: matthias schoeneich <matthias.schoeneich@gmx.net>,
 pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> But if I read the OP correctly the sigma are in fact used additively in e=
ach
> row in blah. =A0"sigma_* =3D sigma_* +"

I apologize, but I omitted a CASE statement prior to each calculation
of the values.  The coefficients for each calculation change depending
upon which case is valid.  I could probably rewrite it using arrays
and may, in fact, do so to eliminate the two added queries.  Thank you
for your input.

-- Gary Chambers

/* Nothing fancy and nothing Microsoft! */