Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AECF8475CB1 for ; Thu, 17 Oct 2002 20:13:56 -0400 (EDT) Received: from lerlaptop.lerctr.org (lerlaptop.lerctr.org [207.158.72.14]) by postgresql.org (Postfix) with ESMTP id 1A916475C9E for ; Thu, 17 Oct 2002 20:13:56 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by lerlaptop.lerctr.org (8.12.6/8.12.5) with ESMTP id g9I0Dlnr000504; Thu, 17 Oct 2002 19:13:47 -0500 (CDT) (envelope-from ler@lerctr.org) Subject: Re: Messy Casts, Is there a better way? From: Larry Rosenman To: Josh Berkus Cc: Peter Eisentraut , pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 17 Oct 2002 19:13:47 -0500 Message-Id: <1034900027.386.2.camel@lerlaptop.lerctr.org> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/200 X-Sequence-Number: 9917 On Thu, 2002-10-17 at 17:50, Josh Berkus wrote: > Larry, > > > If I do that, and enter '72 months' in the contract_term field, how > > can > > I convince PostgreSQL to output the interval back in months? It > > wants > > to give me '5 Years'. > > That's on the TODO list, I'm afraid. From the sound of it, you should > stick with your current schema and custom function. Thanks. At least I know I'm not missing something here. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749