Messages with the subject "Help" usually don't get much response. Also,
this is not a bug report. If you have questions or need help, try the
pgsql-general or pgsql-novice mailing lists (as the bug report form
advised you to do) or ask on the EnterpriseDB forums.
Please do not reply to this message. If you want more help, use one of
the places mentioned above.
When you ask for more help in an appropriate place, rather than just
saying "it doesn't work" please copy and paste the ERROR MESSAGES you
get when you run it. See:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
PostgreSQL 8.1 is obsolete and unmaintained. You should update.
"CREATE IF NOT EXISTS AGGREGATE" is invalid and does not exist, so you
cannot use it. See the help:
---------------------------------
db=> \h create aggregate
Command: CREATE AGGREGATE
Description: define a new aggregate function
Syntax:
CREATE AGGREGATE name ( input_data_type [ , ... ] ) (
SFUNC = sfunc,
STYPE = state_data_type
[ , FINALFUNC = ffunc ]
[ , INITCOND = initial_condition ]
[ , SORTOP = sort_operator ]
)
or the old syntax
CREATE AGGREGATE name (
BASETYPE = base_type,
SFUNC = sfunc,
STYPE = state_data_type
[ , FINALFUNC = ffunc ]
[ , INITCOND = initial_condition ]
[ , SORTOP = sort_operator ]
)
---------------------------------
--
Craig Ringer