Backward compatibility

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Backward compatibility
Date: 2017-07-21 02:13:47
Message-ID: CA+FnnTwNnYv-U98Nuaxqi2jJfTaxbzb+Ezk+ppQEpsX3MnOo1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, ALL,
According to the documentation PostgreSQL 9.6 (latest) supports

CREATE INDEX IF NOT EXIST

However, the version 9.4 and below supports only

CREATE INDEX.

Is there a query or a libpg function which can return the version of
the server I'm running?

And in the latter case - is there a way to check if the index exist?

I guess I will have to query "information_schema" again...

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2017-07-21 02:19:33 Re: Backward compatibility
Previous Message Tom Lane 2017-07-20 22:27:37 Re: Bug in postgres 9.6.2?