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 XAA21055 for postgres-dist; Wed, 26 Jan 1994 23:35:18 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401270735.XAA21055@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 sequent.kiae.su (sequent.kiae.su [144.206.136.6]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id XAA21046 for ; Wed, 26 Jan 1994 23:34:45 -0800 Received: by sequent.kiae.su id AA16155 (5.65.kiae-1 for postgres@postgres.berkeley.edu); Thu, 27 Jan 1994 10:14:44 +0300 Received: by ibrae.msk.su (UUPC/@ v5.09gamma, 14Mar93); Thu, 27 Jan 1994 10:14:21 -0300 To: postgres@postgres.Berkeley.EDU Message-Id: Organization: Nuclear Safety Institute From: Marina Ignatieva Date: Thu, 27 Jan 94 10:14:20 -0300 X-Mailer: BML [MS/DOS Beauty Mail v.1.36] Lines: 20 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Wed, 26 Jan 94 23:35:18 -0800 Resent-XMts: smtp Dear Gurus! I have one question I created some relations: create ex(a=text,b=int4); append ex(a="mar",b=1); append ex(a="ign",b=4); retrieve (ex.all) where int4ne(ex.b,4) This is Ok but when I gave retrieve (ex.all) where textne(ex.a,"mar") I received: type mismatch in invocation of function textne WARN::no such attribute or function textne. The function "textne" is present in pg_proc . Can somebody tell me what is wrong? Best regards, Marina Ignatieva (ign@ibrae.msk.su)_