Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1FGW5E60707 for ; Fri, 15 Feb 2002 11:32:05 -0500 (EST) (envelope-from nickf@ontko.com) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.9.3/8.9.3/Debian 8.9.3-21) with SMTP id LAA32222; Fri, 15 Feb 2002 11:32:08 -0500 X-Authentication-Warning: shire.ontko.com: Host bilbo.ontko.com [199.164.165.101] claimed to be nick Reply-To: From: "Nick Fankhauser" To: "Tom Lane" , , "PGSQL-SQL" Subject: Re: creating an index on a function Date: Fri, 15 Feb 2002 11:27:57 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <14110.1013788811@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal X-Archive-Number: 200202/177 X-Sequence-Number: 6603 Tom, Brent- Thanks for the thoughtful responses. I now understand why it didn't work and what I need to change about my approach. > This raises a subtle point that you'd better think about before you go > too far in this direction: truncating a timestamp to date is not a very > well-defined operation, because it depends on the timezone setting. That's a good point. Fortunately, in this specific application the events are selected by location as a part of the same operation, so I *think* I'll be OK- However, there are some other application functions I'm contemplating for the future which would really get mangled if I lost my TZ information. Regards, -Nick