Received: from geocities.com (mail10.geocities.com [209.1.224.138]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA57071 for ; Mon, 26 Jul 1999 01:22:05 -0400 (EDT) (envelope-from dan_wilson@geocities.com) Received: from dwilson (bbudnick.employees.fiber.net [216.83.131.7]) by geocities.com (8.9.3/8.9.3) with ESMTP id WAA04268 for ; Sun, 25 Jul 1999 22:22:01 -0700 (PDT) Message-ID: <008801bed726$ffdc2860$ac0bfea9@dwilson> From: "Dan Wilson" To: "pgsql general" Subject: escaping wildcard chars Date: Sun, 25 Jul 1999 23:16:52 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 I am trying to pull in the different types allowed by postgres for a create function statement and am having problems with the types that start with an underscore (_). Because the underscore is the wildcard for a single character, I cannot perform the following query correctly. SELECT typname from pg_type WHERE NOT LIKE '_%' It gives me an empty set. Is there any way to escape the underscore. I tried to use '\_%', but that didn't help. Any suggestions? -Dan