Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA23538 for postgres-dist; Thu, 18 Nov 1993 12:39:51 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311182039.MAA23538@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from arcadia.CS.Berkeley.EDU (arcadia.CS.Berkeley.EDU [128.32.149.40]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id MAA23528 for ; Thu, 18 Nov 1993 12:39:50 -0800 Received: from localhost (localhost [127.0.0.1]) by arcadia.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA29124; Thu, 18 Nov 1993 12:39:29 -0800 Message-Id: <199311182039.MAA29124@arcadia.CS.Berkeley.EDU> X-Authentication-Warning: arcadia.CS.Berkeley.EDU: Host localhost didn't use HELO protocol To: John Peter Lee cc: postgres@postgres.Berkeley.EDU, john@cs.uml.edu (John C. Sieg), grinstei@cs.uml.edu (Georges Grinstein) Subject: Re: negative floats In-reply-to: Your message of "Thu, 18 Nov 93 15:13:18 EST." <199311182013.AA18435@cs.uml.edu> Date: Thu, 18 Nov 93 12:39:29 -0800 From: Jolly Chen Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Thu, 18 Nov 93 12:39:51 -0800 Resent-XMts: smtp > It seems that Postgres cannot handle negative floating point numbers. > Is this true, and is it fixed in 4.1 (or in 5.0), or how can we fix > it ourselves? This is a very important part of the application that uses > Postgres . > > Please help. > > thanks, > > jp Postgres does handle negative floating point numbers, but our parser doesn't handle negative floating point constants very well. To get around your problem, use double-quotes around your constant. For example, * append foo(name = "dave", val = "-1.0")\g It wouldn't hurt to cast it to the right type, either, and you should definitely explictly cast any constants of user-defined types. - Jolly Chen