Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAL0cEm50900 for ; Tue, 20 Nov 2001 19:38:14 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fAL0SmL56082 for pgsql-sql@postgresql.org; Tue, 20 Nov 2001 19:28:48 -0500 (EST) (envelope-from news) From: caldodge@fpcc.net (Calvin Dodge) X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Optimization with dates Date: 20 Nov 2001 16:28:41 -0800 Organization: http://groups.google.com/ Lines: 25 Message-ID: References: <72319017913.20011114005656@thefreecat.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200111/299 X-Sequence-Number: 5681 cat@thefreecat.org (Jean-Christophe Boggio) wrote in message news:<72319017913.20011114005656@thefreecat.org>... > I have tried : > where dategain>=(select now()-30); > where dategain+30>='now' > where date(dategain)>=date('now')-30 > and many other, syntactically absurd :-) > > Anyone can help me use this index ?