Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311182013.MAA23163@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: John Peter Lee <jlee@cs.uml.edu>
Message-Id: <199311182013.AA18435@cs.uml.edu>
Subject: negative floats
To: postgres@postgres.Berkeley.EDU
Date: Thu, 18 Nov 1993 15:13:18 -0500 (EST)
Cc: john@cs.uml.edu (John C. Sieg), grinstei@cs.uml.edu (Georges Grinstein)
Content-Type: text
Content-Length: 1236      
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Thu, 18 Nov 93 12:13:23 -0800
Resent-XMts: smtp

Hi:

   I've noticed what could amount to be a big problem in Postgres 4.0.1,
   as I indicated in an earlier posting. This session should make it
   clear what the problem is:

Welcome to the C POSTGRES terminal monitor

Go 
* create foo (name = text, val = float4)\g

Query sent to backend is "create foo (name = text, val = float4)"
CREATE
Go 
* append foo(name = "jp", val = 1.0)\g

Query sent to backend is "append foo(name = "jp", val = 1.0)"
APPEND 152686
Go 
* append foo(name = "dave", val = -1.0)\g

Query sent to backend is "append foo(name = "dave", val = -1.0)"
WARN:Nov 18 15:05:54:unequal type in tlist : val 


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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
JP Lee               Institute for Visualization and Perception Research	
jlee@cs.uml.edu                    University of Massachusetts at Lowell 
(508) 934-3384			      1 University Ave. Lowell, MA 01854

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~