Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA26684 for ; Tue, 15 Jun 1999 09:51:37 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 9D6154B567; Tue, 15 Jun 1999 16:51:31 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA5BA1; Tue, 15 Jun 1999 16:54:11 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <22557.929453996@sss.pgh.pa.us> References: Your message of Tue, 15 Jun 1999 11:17:08 +0800 <3765C5B3.C05DC56D@chemquick.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 15 Jun 1999 16:52:41 +0300 To: Tom Lane , vikrant@chemquick.com From: Herouth Maoz Subject: Re: [SQL] Mail about typecast Cc: pgsql-sql@postgreSQL.org At 16:39 +0300 on 15/06/1999, Tom Lane wrote: > select date_part('epoch','12 hours'::timespan) AS float4; Probably missing a CAST keyword here, isn't it? Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma