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 PAA21972 for postgres-dist; Sun, 3 Apr 1994 15:54:50 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404032254.PAA21972@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id PAA21963 for ; Sun, 3 Apr 1994 15:54:50 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id PAA03963; Sun, 3 Apr 1994 15:54:27 -0700 Message-Id: <199404032254.PAA03963@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: Paulo Franklin Von Paumgartten Junior Cc: postgres@postgres.Berkeley.EDU Subject: Re: float operators Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Sun, 03 Apr 1994 10:02:03 -0300 (EST) Date: Sun, 03 Apr 94 15:54:27 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Sun, 03 Apr 94 15:54:50 -0700 Resent-XMts: smtp Paulo Franklin Von Paumgartten Junior writes: > 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 this has to do with the default type for a floating point constant. the solution to this is described (1) in the manual and (2) in the error message, i.e., typecast the constant: "567.91"::float4 -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki