From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | Christoph Moench-Tegeder <cmt(at)burggraben(dot)net> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: What is the problem with this query? |
Date: | 2017-07-23 21:35:35 |
Message-ID: | CA+FnnTyri_io4zA-Bk_iiqAGRfT3zre_+J41C5YDhXo3rENEnw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, Christoph,
On Sun, Jul 23, 2017 at 5:30 PM, Christoph Moench-Tegeder
<cmt(at)burggraben(dot)net> wrote:
> ## Igor Korot (ikorot01(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | PT | 2017-07-23 22:40:31 | Re: Perfomance of IN-clause with many elements and possible solutions |
Previous Message | Christoph Moench-Tegeder | 2017-07-23 21:30:11 | Re: What is the problem with this query? |