Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1A8FA9FB8AD for ; Wed, 25 Jul 2007 10:35:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 01393-07 for ; Wed, 25 Jul 2007 10:35:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.planetcobalt.net (mail.planetcobalt.net [217.10.9.49]) by postgresql.org (Postfix) with ESMTP id 5F75C9FB6DC for ; Wed, 25 Jul 2007 10:35:14 -0300 (ADT) Received: by mail.planetcobalt.net (Postfix, from userid 1000) id 69FD53C00084; Wed, 25 Jul 2007 15:35:12 +0200 (CEST) Date: Wed, 25 Jul 2007 15:35:12 +0200 From: Ansgar -59cobalt- Wiechers To: pgsql-performance@postgresql.org Subject: Re: index over timestamp not being used Message-ID: <20070725133512.GA19159@mail.planetcobalt.net> References: <46A64475.3040201@andromeiberica.com> <46A6537B.6010604@andromeiberica.com> <15140.1185306195@sss.pgh.pa.us> <200707251505.11182.mweilguni@sime.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200707251505.11182.mweilguni@sime.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/340 X-Sequence-Number: 26024 On 2007-07-25 Mario Weilguni wrote: > Am Dienstag 24 Juli 2007 schrieb Tom Lane: >>> I thought the to_char/to_date/to_timestamp functions were intented >>> for this purposes >> >> No, they're intended for dealing with wacky formats that the regular >> input/output routines can't understand or produce. > > Really? I use them alot, because of possible problems with different > date formats. 20070503 means May 3, 2007 for germans, Actually, no. 20070503 is the condensed form of the ISO international calendar date format (see ISO 8601). German formats would be 03.05.2007 or 3. Mai 2007. Regards Ansgar Wiechers -- "The Mac OS X kernel should never panic because, when it does, it seriously inconveniences the user." --http://developer.apple.com/technotes/tn2004/tn2118.html