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 JAA23874 for postgres-dist; Thu, 27 Jan 1994 09:11:29 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401271711.JAA23874@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 utig.ig.utexas.edu (utig.ig.utexas.edu [129.116.200.10]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id JAA23865 for ; Thu, 27 Jan 1994 09:11:28 -0800 Received: from rimu.ig.utexas.edu.utig by utig.ig.utexas.edu (4.1/SMI-4.1) id AA13812; Thu, 27 Jan 94 10:55:03 CST Date: Thu, 27 Jan 94 10:55:03 CST From: scottk@utig.ig.utexas.edu (Scott Kempf) Message-Id: <9401271655.AA13812@utig.ig.utexas.edu> To: ign@ibrae.msk.su, postgres@postgres.Berkeley.EDU Subject: Passing text to functions question. Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 27 Jan 94 09:11:29 -0800 Resent-XMts: smtp Postgres treats uncasted text strings as type text most of the time. When they strings are passed to function, they are type unknown. What you need to do is cast the string to type text. retrieve (ex.all) where textne(ex.a,"mar"::text) ^^^^^^ Scott