Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 586804762DB for ; Tue, 15 Oct 2002 14:48:27 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 5E0B0476551 for ; Tue, 15 Oct 2002 14:48:13 -0400 (EDT) Received: (qmail 2007 invoked by uid 0); 15 Oct 2002 18:48:13 -0000 Received: from pd902f0a9.dip0.t-ipconnect.de (217.2.240.169) by mail.gmx.net (mp001-rz3) with SMTP; 15 Oct 2002 18:48:12 -0000 Date: Tue, 15 Oct 2002 20:54:23 +0200 (CEST) From: Peter Eisentraut X-X-Sender: peter@localhost.localdomain To: Larry Rosenman Cc: pgsql-sql@postgresql.org Subject: Re: Messy Casts, Is there a better way? In-Reply-To: <1034676979.436.1.camel@lerlaptop.lerctr.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/166 X-Sequence-Number: 9883 Larry Rosenman writes: > I have a table with the following, in part: > > contract_start date > contract_term int (term in MONTHS) Store contract_term as interval? -- Peter Eisentraut peter_e@gmx.net