Received: from actarg.com (host25.actarg.com [209.180.91.25] (may be forged)) by postgresql.org (8.11.3/8.11.1) with ESMTP id f37Id6800422 for ; Sat, 7 Apr 2001 14:39:06 -0400 (EDT) (envelope-from kyle@actarg.com) Received: from chi.actarg.com (IDENT:root@chi.actarg.com [192.168.2.16]) by actarg.com (8.9.3/8.9.3) with ESMTP id MAA20527; Sat, 7 Apr 2001 12:37:22 -0600 Received: from actarg.com (IDENT:kyle@localhost [127.0.0.1]) by chi.actarg.com (8.9.3/8.9.3) with ESMTP id MAA12903; Sat, 7 Apr 2001 12:37:32 -0600 Message-ID: <3ACF5E6C.51106D1C@actarg.com> Date: Sat, 07 Apr 2001 12:37:32 -0600 From: Kyle Organization: Action Target Inc. X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: tgl@sss.pgh.pa.us CC: pgsql-sql@postgresql.org Subject: Update Content-Type: multipart/mixed; boundary="------------E66CC80EE3EBF8112396B762" X-Archive-Number: 200104/102 X-Sequence-Number: 2442 This is a multi-part message in MIME format. --------------E66CC80EE3EBF8112396B762 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit OK, I figured it out. It wasn't the sum(int4) thing... I have a query that looks like this: select pnum from part where func1(pnum) and func2(pnum); Func1 takes less time to execute than func2. I was using func1 to "narrow the field" of records so the query would not take so long to execute. After upgrading to 7.1 the query got real slow. After changing the query to: select pnum from part where func2(pnum) and func1(pnum); The query went back to its normal time. It appears that the first function would get evaluated first under 7.0.3 but the last function gets evaluated first under 7.1. Is that accurate? Is there a way to control which functions are given precidence? Kyle --------------E66CC80EE3EBF8112396B762 Content-Type: text/x-vcard; charset=us-ascii; name="kyle.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Kyle Content-Disposition: attachment; filename="kyle.vcf" begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:kyle@actarg.com title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard --------------E66CC80EE3EBF8112396B762--