Hi, Christoph, On Sun, Jul 23, 2017 at 5:30 PM, Christoph Moench-Tegeder <c...@burggraben.net> wrote: > ## Igor Korot (ikoro...@gmail.com): > >> >> Is "IF" operator not supported by PostgreSQL >> So how do I write this properly? > > There is documentation for that: > https://www.postgresql.org/docs/current/static/sql-createindex.html
Except that IF NOT EXIST clause is introduced in 9.5. And if the server is <= 9.4? I tried to use a solution from here: https://dba.stackexchange.com/questions/35616/create-index-if-it-does-not-exist. but apparently I fail. Thank you. > > Regards, > Christoph > > -- > Spare Space > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
