Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 433CA9FB1C2 for ; Wed, 4 Oct 2006 10:35:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 02400-02 for ; Wed, 4 Oct 2006 10:35:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B45539FA186 for ; Wed, 4 Oct 2006 10:35:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from bay0-omc2-s32.bay0.hotmail.com (bay0-omc2-s32.bay0.hotmail.com [65.54.246.168]) by svr4.postgresql.org (Postfix) with ESMTP id 6A6075AF03A for ; Wed, 4 Oct 2006 13:35:46 +0000 (GMT) Received: from hotmail.com ([207.46.10.86]) by bay0-omc2-s32.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 4 Oct 2006 06:35:44 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 4 Oct 2006 06:35:44 -0700 Message-ID: Received: from 207.46.10.123 by by121fd.bay121.hotmail.msn.com with HTTP; Wed, 04 Oct 2006 13:35:42 GMT X-Originating-IP: [199.42.80.225] X-Originating-Email: [chrisj.wood@sympatico.ca] X-Sender: chrisj.wood@sympatico.ca In-Reply-To: <452379DC.8080205@logix-tt.com> From: "christopher wood" To: schabi@logix-tt.com, ajs@crankycanuck.ca Cc: pgsql-sql@postgresql.org, dan.gibson@3web.com Subject: Re: Assigning a timestamp without timezone to a timestamp Date: Wed, 04 Oct 2006 13:35:42 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 04 Oct 2006 13:35:44.0241 (UTC) FILETIME=[FDF6BE10:01C6E7B9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.069 tagged_above=0 required=5 tests=MSGID_FROM_MTA_HEADER, SPF_NEUTRAL X-Spam-Level: * X-Archive-Number: 200610/37 X-Sequence-Number: 26426 Thanks Markus, But I can't even take credit for that, my business partner suggested using Postgres. I have been a DB2 DBA most of my professional life (25 years) until recently, and a huge proponent of DB2 against the likes of Oracle and MS-SQL. So far I am very impressed with Postgres but there is a lot more in Postgres to get one's head around. I certainly appreciate having people like you and Andrew to help me along. God Bless, - chris >From: Markus Schaber >To: Andrew Sullivan >CC: chrisj , pgsql-sql@postgresql.org >Subject: Re: [SQL] Assigning a timestamp without timezone to a timestamp >Date: Wed, 04 Oct 2006 11:07:40 +0200 > >Hi, Chris, >Hi, Andrew, > >Chrisj wrote: > > > please be patient with me sometimes I am slow but I usually get there. > > >Andrew Sullivan wrote: > > Sorry, I'm dim, > > > Told you I'm dim. > > >That's just plain wrong. You guys are using PostgreSQL, and that's the >proof that you're the brightest people on the planet. :-) > > >HTH, >Markus >-- >Markus Schaber | Logical Tracking&Tracing International AG >Dipl. Inf. | Software Development GIS > >Fight against software patents in Europe! www.ffii.org >www.nosoftwarepatents.org