Return-Path: postman 
Delivery-Date: Mon, 30 Aug 93 19:29:59 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19831; Mon, 30 Aug 93 19:26:31 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308310226.AA19831@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: @sol.csee.usf.edu:almadani@zeus.csee.usf.edu
Received: from sol.csee.usf.edu by postgres.Berkeley.EDU (5.61/1.29)
	id AA19823; Mon, 30 Aug 93 19:26:26 -0700
Received: from zeus.csee.usf.edu by sol.csee.usf.edu (4.1/25-eef)
	id AA00445; Mon, 30 Aug 93 22:35:25 EDT
Received: by zeus.csee.usf.edu (4.1/25-eef)
	id AA13655; Mon, 30 Aug 93 22:36:21 EDT
Date: Mon, 30 Aug 93 22:36:21 EDT
From: Nabiel Al-Madani <almadani@zeus.csee.usf.edu>
Message-Id: <9308310236.AA13655@zeus.csee.usf.edu>
To: postgres@postgres.Berkeley.EDU
Subject: Postquel queries
Resent-To: postgres-dist
Resent-Date: Mon, 30 Aug 93 19:26:30 PDT

Hi,

I have two questions concerning Postquel queries. The first is, are there any
floating point binary operators defined in postgres? I typed the following
query:

retrieve (emp.all) where emp.salary > 35000.00\g

where

emp is defined as: emp(ss_no = int4, salary = float4), and postgres responded
by the following message:

Query sent to backend is "retrieve (emp.all) where emp.salary > 35000.00"
NOTICE:Aug 27 04:09:31:there is no operator > for types float4 and float8
NOTICE:Aug 27 04:09:31:You will either have to retype this query using an
NOTICE:Aug 27 04:09:31:explicit cast, or you will have to define the operator
WARN:Aug 27 04:09:31:> for float4 and float8 using DEFINE OPERATOR

if there is none, then how can I explicitly cast the query.

My second question is about the following query:

retrieve (student.all) where student.Id = TA.Id or student.Id = RA.Id\g

where student(Id = int4, name = text)
      TA (Id = int4, name = text)
      RA (Id = int4, name = text)

Postgres responded by the following message:

    Error: No response from the backend, exiting...

I should mention that I tried the same query with an "and" instead of an "or"
in the where clause and the query produced the right results.

I would appreciate any help regarding the above questions. Thanks and best
regards,

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
     Nabeil Al-Madani                 Computer Science & Engineering
almadani@zeus.csee.usf.edu          University of South Florida, Tampa
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=