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 f3DEwQ846823 for ; Fri, 13 Apr 2001 10:58:26 -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 IAA00521; Fri, 13 Apr 2001 08:58:21 -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 IAA06344; Fri, 13 Apr 2001 08:58:24 -0600 Message-ID: <3AD71410.F2A1B252@actarg.com> Date: Fri, 13 Apr 2001 08:58:24 -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: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: Update References: <3ACF5E6C.51106D1C@actarg.com> <2092.987131009@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="------------489B55985616DD55D96BEB40" X-Archive-Number: 200104/193 X-Sequence-Number: 2543 This is a multi-part message in MIME format. --------------489B55985616DD55D96BEB40 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > Kyle writes: > > 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? > > Actually, I was under the impression that (all else being equal) WHERE > clauses would get evaluated right-to-left in 7.0.* as well. I was > meaning to figure out where the clause order reversal is happening and > undo it, but didn't get around to it for 7.1. > > > Is there a way to control which functions are given precidence? > > Nope, not at the moment. The code has remnants of a notion of cost of > evaluation for functions, but it's not being used for anything ... > Might be interesting to have something like: create function ... as ... with cost=x; It would also be cool to supply a default set of parameters to the function. Then "vaccum analyze" or some such thing could execute the functions, time them, and store cost data internally... create function ... as ... with default(3,7,4); or create function myfunc (int4 3, float8 7, numeric 4) ...; BTW, great job on 7.1! Kudos to all the developers who are working so hard to make it happen. --------------489B55985616DD55D96BEB40 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 --------------489B55985616DD55D96BEB40--