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 Bartunov||Date: 1999-07-26 06:13:54|
|Subject: Re: [SQL] inserts/updates problem under stressing !|
|Previous:||From: firstname.lastname@example.org||Date: 1999-07-26 04:52:42|
|Subject: Re: [SQL] Expr Abbreviations/Functions?|
pgsql-general by date
|Next:||From: Giuseppe Frangiamone||Date: 1999-07-26 11:26:27|
|Subject: declarative foreign keys in Postgresql|
|Previous:||From: Dan Wilson||Date: 1999-07-26 02:30:53|
|Subject: Re: [GENERAL] pg-dump -- primary Key|