Re: How to check the postgresql version

Joe Conway wrote:
> Along those lines, this is what I've been using in PL/R:
> 
> #if (CATALOG_VERSION_NO <= 200211021)
> #define PG_VERSION_73_COMPAT
> #elif (CATALOG_VERSION_NO <= 200310211)
> #define PG_VERSION_74_COMPAT
> #else
> #define PG_VERSION_80_COMPAT
> #endif
> 
> I wasn't following this thread earlier, but if you need to distinguish 
> between, for example, 7.4.3 and 7.4.6, the above won't help. If you just 
> need major Postgres version, it works well.
> 
PL/Java used to have this in the Makefile.

SS_VERSION := $(subst ., ,$(subst devel,.devel,$(VERSION)))
PGSQL_MAJOR_VER    = $(word 1,$(SS_VERSION))
PGSQL_MINOR_VER    = $(word 2,$(SS_VERSION))
PGSQL_PATCH_VER    = $(word 3,$(SS_VERSION))

override CPPFLAGS := \-DPGSQL_MAJOR_VER=$(PGSQL_MAJOR_VER) \-DPGSQL_MINOR_VER=$(PGSQL_MINOR_VER)
\-DPGSQL_PATCH_VER=$(PGSQL_MINOR_VER)

but I later removed the PGSQL_PATCH_VER since I don't plan to support 
different binaries for different patch levels. I'll try to do that using 
a more dynamic approach (i.e. through "SELECT version").

In the code, I do things like:

#if PGSQL_MAJOR_VER >= 8

or

#if PGSQL_MAJOR_VER == 7 && PGSQL_MINOR_VER < 3

Regards,
Thomas Hallgren