escaping wildcard chars

Поиск
Список
Период
Сортировка
От Dan Wilson
Тема escaping wildcard chars
Дата
Msg-id 008801bed726$ffdc2860$ac0bfea9@dwilson
обсуждение исходный текст
Ответы Re: [GENERAL] escaping wildcard chars  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Dan Wilson"
Дата:
Сообщение: Re: [GENERAL] pg-dump -- primary Key
Следующее
От: "Giuseppe Frangiamone"
Дата:
Сообщение: declarative foreign keys in Postgresql