Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 20B519FA687 for ; Fri, 14 Sep 2007 10:36:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 74242-10 for ; Fri, 14 Sep 2007 10:36:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.239]) by postgresql.org (Postfix) with ESMTP id 79E469FA65E for ; Fri, 14 Sep 2007 10:36:49 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id o12so914700qba for ; Fri, 14 Sep 2007 06:36:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=zBjx6us+pGRjUjddxzLrgnBcHQB7BEcb9IzJVft4VXY=; b=J6wYbApld7mlP1WSBPs9nLaeE/igRJYLroYAv2h/bXTT+dDV56jYDl9iMKsTQW8jy7G6BVm+pfOmudlwCotZHkacnhKUwUIrD4X8y4Gy18sGESxn44GIwQUIglFubtKVaA56aF0OZ5NiC9IL5QuYFKrLdWiUTP/LcSPwk02/pWo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=f1pQ8+FTht11ezU2fu3XC9UEKnV/2oCLfCw1EdV2P4k1BuCUSCA2kisj/cybc3G3ZFL7JxhALZ7pmZyHZEZnCMevgdpfekQaJJilE1yJtr3q30+1ZBNPOXdS0gLW/yBSwsobwsMgC7OxZ86huaGfVgKuRrk/0Jv/bfhs1yCCJ9Y= Received: by 10.67.98.20 with SMTP id a20mr442280ugm.1189777007391; Fri, 14 Sep 2007 06:36:47 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Fri, 14 Sep 2007 06:36:47 -0700 (PDT) Message-ID: Date: Fri, 14 Sep 2007 08:36:47 -0500 From: "Scott Marlowe" To: "A. Kretschmer" Subject: Re: Optimize querry sql Cc: pgsql-sql@postgresql.org In-Reply-To: <20070914084952.GB7443@a-kretschmer.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070914084952.GB7443@a-kretschmer.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/111 X-Sequence-Number: 29324 On 9/14/07, A. Kretschmer wrote: > And use CURRENT_DATE instead now(). Out of curiosity, why the advice to switch from now() to CURRENT_DATE?