Running CREATE only on certain Postgres versions - Mailing list pgsql-general

From Robert James
Subject Running CREATE only on certain Postgres versions
Date
Msg-id CAGYyBgj+cFCDST4KSqM7o_FSpKA+B5Ynm-bxrKeJ7rX0+-aWUw@mail.gmail.com
Whole thread Raw
Responses Re: Running CREATE only on certain Postgres versions
Re: Running CREATE only on certain Postgres versions
List pgsql-general
I have some code which creates a function in Postgres, taken from
http://wiki.postgresql.org/wiki/Array_agg .

DROP AGGREGATE IF EXISTS array_agg(anyelement);
CREATE AGGREGATE array_agg(anyelement) (
SFUNC=array_append,
STYPE=anyarray,
INITCOND='{}'
);

The function was added in 8.4, and so the code fails when run on 8.4 or higher.

How can I make the code cross-version compatible? For instance, how
can I tell it to check the version, and only run if 8.3 or lower?   Or
another way to make it cross-version?


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: 9.1 vs 8.4 performance
Next
From: "W. Matthew Wilson"
Date:
Subject: How to do a full-text search words within some proximity of each other?