Re: [GENERAL] What is the problem with this query? - Mailing list pgsql-general

From Igor Korot
Subject Re: [GENERAL] What is the problem with this query?
Date
Msg-id CA+FnnTyri_io4zA-Bk_iiqAGRfT3zre_+J41C5YDhXo3rENEnw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] What is the problem with this query?  (Christoph Moench-Tegeder <cmt@burggraben.net>)
List pgsql-general
Hi, Christoph,

On Sun, Jul 23, 2017 at 5:30 PM, Christoph Moench-Tegeder
<cmt@burggraben.net> wrote:
> ## Igor Korot (ikorot01@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


pgsql-general by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: [GENERAL] What is the problem with this query?
Next
From: PT
Date:
Subject: Re: [GENERAL] Perfomance of IN-clause with many elements andpossible solutions