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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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?
-Dan
From | Date | Subject | |
---|---|---|---|
Next Message | Giuseppe Frangiamone | 1999-07-26 11:26:27 | declarative foreign keys in Postgresql |
Previous Message | Dan Wilson | 1999-07-26 02:30:53 | Re: [GENERAL] pg-dump -- primary Key |
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1999-07-26 06:13:54 | Re: [SQL] inserts/updates problem under stressing ! |
Previous Message | tjk@tksoft.com | 1999-07-26 04:52:42 | Re: [SQL] Expr Abbreviations/Functions? |