[GENERAL] What is the problem with this query?

Поиск
Список
Период
Сортировка
От Igor Korot
Тема [GENERAL] What is the problem with this query?
Дата
Msg-id CA+FnnTyGHBKZeTRNrR780TF51uPaRyT=apNgX=QaBwfbp7H94w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] What is the problem with this query?
Список pgsql-general
Hi, ALL,

draft=# IF NOT EXISTS( SELECT 1 FROM pg_class c, pg_namespace n WHERE
n.oid = c.relnamespace AND c.relname = 'abcattbl_tnam_ownr' AND
n.nspname = 'public' ) THEN CREATE INDEX "abcattbl_tnam_ownr" ON
"abcattbl"("abt_tnam" ASC, "abt_ownr" ASC);
ERROR:  syntax error at or near "IF"
LINE 1: IF NOT EXISTS( SELECT 1 FROM pg_class c, pg_namespace n WHER...
        ^

Is "IF" operator not supported by PostgreSQL?

Thank you.


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] pg_dump not dropping event trigger
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] What is the problem with this query?