Skip site navigation (1) Skip section navigation (2)

escaping wildcard chars

From: "Dan Wilson" <dan_wilson(at)geocities(dot)com>
To: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: escaping wildcard chars
Date: 1999-07-26 05:16:52
Message-ID: 008801bed726$ffdc2860$ac0bfea9@dwilson (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-sql
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?



pgsql-sql by date

Next:From: Oleg BartunovDate: 1999-07-26 06:13:54
Subject: Re: [SQL] inserts/updates problem under stressing !
Previous:From: tjk@tksoft.comDate: 1999-07-26 04:52:42
Subject: Re: [SQL] Expr Abbreviations/Functions?

pgsql-general by date

Next:From: Giuseppe FrangiamoneDate: 1999-07-26 11:26:27
Subject: declarative foreign keys in Postgresql
Previous:From: Dan WilsonDate: 1999-07-26 02:30:53
Subject: Re: [GENERAL] pg-dump -- primary Key

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group