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 IAA20295 for postgres-dist; Sun, 3 Apr 1994 08:11:30 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404031511.IAA20295@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from fpsp.fapesp.br (fpsp.fapesp.br [143.108.1.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id IAA20286 for <postgres@nobozo.CS.Berkeley.EDU>; Sun, 3 Apr 1994 08:11:26 -0700
Received: from itep.itep.br by fpsp.fapesp.br with PMDF#10108; Sun, 3 Apr 1994
 12:11 BSC (-0300 C)
Received: from di.ufpe.br (recife.di.ufpe.br) by itep.itep.br (PMDF V4.2-11
 #3257) id <01HAQG3Y4SCW000BW4@itep.itep.br>; Sun, 3 Apr 1994 09:58:21 -0300
Received: by di.ufpe.br (4.1/SMI-4.1) id AA18597; Sun, 3 Apr 94 10:02:04 EST
Date: Sun, 03 Apr 1994 10:02:03 -0300 (EST)
From: Paulo Franklin Von Paumgartten Junior <pfvpj@di.ufpe.br>
Subject: float operators
To: postgres@postgres.Berkeley.EDU
Message-id: <Pine.3.89.9404030925.A18559-0100000@recife>
X-Envelope-to: postgres@nobozo.CS.Berkeley.EDU
Content-type: TEXT/PLAIN; charset=US-ASCII
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Sun, 03 Apr 94 08:11:30 -0700
Resent-XMts: smtp



 Are there any problems with float type operators?
I have tryed to use the operator '=' in a query and
have received the following message:

Query sent to backend is "retrieve 
(ent1.all) where ent1.att_1 = 567.91 "
NOTICE:Apr  3 09:58:52:there is no operator = for types float4 and float8
NOTICE:Apr  3 09:58:52:You will either have to retype this query using an
NOTICE:Apr  3 09:58:52:explicit cast, or you will have to define the 
operator


Thanks ,

Paulo Franklin

 


