Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5EDEC9FA652 for ; Fri, 14 Sep 2007 12:17:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 87077-01 for ; Fri, 14 Sep 2007 12:17:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from hu-out-0506.google.com (hu-out-0506.google.com [72.14.214.235]) by postgresql.org (Postfix) with ESMTP id 6B5A29FA33C for ; Fri, 14 Sep 2007 12:17:15 -0300 (ADT) Received: by hu-out-0506.google.com with SMTP id 22so394356hug for ; Fri, 14 Sep 2007 08:17:14 -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=hc70uGVvx3f7XboohEiyWvnJ9b3HQTdQlYCdWuiesHM=; b=FlziBfPuCykHpxECBytFLfu8iwu9Ci9+V1xGEMZabpK6ybxaRx8JCBna66C1PvogH1bd5mwlS1qtV7HLRdMVfIf6cUte1T08Rzk3VyZtpSpeuGF6u45y6wlO3Y++iyBHY1GV6xS1DzngEdM1fallLhBr9DqEWPCRX+ykY6N1YlM= 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=FUx5UGB9oa6NUbKc9zG4Zo08KqYr4kFdS9Ja3+J02DTz4yl/3i5Qomcw/Gvz/XXwzdeXXigm6DcdR3aU9lbKYNtKyrloSj/afLtMY9yLJ7LbVe262bdZU4ow9v6llhpWwPfz7VQFamYxbO1uOUdtKSQFJ0CO530KHSP+PvanMvY= Received: by 10.66.239.16 with SMTP id m16mr3884764ugh.1189783033826; Fri, 14 Sep 2007 08:17:13 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Fri, 14 Sep 2007 08:17:13 -0700 (PDT) Message-ID: Date: Fri, 14 Sep 2007 10:17:13 -0500 From: "Scott Marlowe" To: "A. Kretschmer" Subject: Re: Optimize querry sql Cc: pgsql-sql@postgresql.org In-Reply-To: <20070914145202.GA24546@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> <20070914145202.GA24546@a-kretschmer.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/113 X-Sequence-Number: 29326 On 9/14/07, A. Kretschmer wrote: > am Fri, dem 14.09.2007, um 8:36:47 -0500 mailte Scott Marlowe folgendes: > > 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? > > Mhh, don't know... OK, I was just afraid there was some "bad thing" TM that I wasn't aware of with now(), which, btw, I use all the time. whew.