[GENERAL] Backward compatibility - Mailing list pgsql-general

From Igor Korot
Subject [GENERAL] Backward compatibility
Date
Msg-id CA+FnnTwNnYv-U98Nuaxqi2jJfTaxbzb+Ezk+ppQEpsX3MnOo1Q@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Backward compatibility  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: [GENERAL] Backward compatibility  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Bug in postgres 9.6.2?
Next
From: Andreas Kretschmer
Date:
Subject: Re: [GENERAL] Backward compatibility