Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA26729; Thu, 20 Feb 92 21:49:57 -0800
Date: Thu, 20 Feb 92 21:49:57 -0800
Message-Id: <9202210549.AA26729@postgres.Berkeley.EDU>
From: shetty <TSRS00%SDNET.BITNET@cmsa.Berkeley.EDU>
Subject: != operator
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: Netters <postgres@postgres.Berkeley.EDU>

Hi Netters,
          I would like to refer to page 7 of user Manual, Sec6.2.6 Joins
     * retrieve (E1.name, E2.name)
           from E1 in EMP, E2 in EMP
           where E1.age=E2.age
           and E1.name != E2.name   \g
When I run this query, It says there is no operator != for types _char and
_char, You will either have to type this query using explicit cast, or you
will have to define the operator != for _char and _char using DEFINE operator
        Does anybody have the idea why this occur and how this can be corrected
please write back on the network or send me mail.

Thanks in advance,
    Ramesh Shetty [ tsrs00@sdnet.bitnet.edu ]