X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 17F08D1F353 for ; Thu, 6 May 2004 22:38:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 47458-02 for ; Thu, 6 May 2004 22:38:42 -0300 (ADT) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id C8CE0D1F35A for ; Thu, 6 May 2004 22:38:37 -0300 (ADT) Received: from [192.168.0.40] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id i471cXWL044366; Fri, 7 May 2004 09:38:33 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <409AE9EE.1070409@familyhealth.com.au> Date: Fri, 07 May 2004 09:44:14 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Gaetano Mendola , pgsql-hackers@postgresql.org Subject: Re: [ADMIN] cast not IMMUTABLE? References: <26503.1083890514@sss.pgh.pa.us> In-Reply-To: <26503.1083890514@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/367 X-Sequence-Number: 53445 > (login_time at time zone 'GMT')::date > but upon experimenting I see that that isn't considered immutable either > :-(. Offhand I think this may be an oversight --- I can't see any reason > for the various flavors of AT TIME ZONE (a/k/a timezone() function) > not to be considered immutable. (Hackers, any comments?) Seems reasonable...seems like the kind of thing that wouldn't have been tested/considered... Chris