added "or replace"
diff --git a/sql/datasketches_aod_sketch.sql b/sql/datasketches_aod_sketch.sql
index 870d42b..e3788c6 100644
--- a/sql/datasketches_aod_sketch.sql
+++ b/sql/datasketches_aod_sketch.sql
@@ -86,7 +86,7 @@
AS '$libdir/datasketches', 'pg_aod_sketch_deserialize_state'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE aod_sketch_build(anyelement, double precision[]) (
+CREATE OR REPLACE AGGREGATE aod_sketch_build(anyelement, double precision[]) (
STYPE = internal,
SFUNC = aod_sketch_build_agg,
COMBINEFUNC = aod_sketch_union_combine,
@@ -96,7 +96,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_build(anyelement, double precision[], int) (
+CREATE OR REPLACE AGGREGATE aod_sketch_build(anyelement, double precision[], int) (
STYPE = internal,
SFUNC = aod_sketch_build_agg,
COMBINEFUNC = aod_sketch_union_combine,
@@ -106,7 +106,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_build(anyelement, double precision[], int, real) (
+CREATE OR REPLACE AGGREGATE aod_sketch_build(anyelement, double precision[], int, real) (
STYPE = internal,
SFUNC = aod_sketch_build_agg,
COMBINEFUNC = aod_sketch_union_combine,
@@ -116,7 +116,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_union(aod_sketch) (
+CREATE OR REPLACE AGGREGATE aod_sketch_union(aod_sketch) (
STYPE = internal,
SFUNC = aod_sketch_union_agg,
COMBINEFUNC = aod_sketch_union_combine,
@@ -126,7 +126,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_union(aod_sketch, int) (
+CREATE OR REPLACE AGGREGATE aod_sketch_union(aod_sketch, int) (
STYPE = internal,
SFUNC = aod_sketch_union_agg,
COMBINEFUNC = aod_sketch_union_combine,
@@ -136,7 +136,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_union(aod_sketch, int, int) (
+CREATE OR REPLACE AGGREGATE aod_sketch_union(aod_sketch, int, int) (
STYPE = internal,
SFUNC = aod_sketch_union_agg,
COMBINEFUNC = aod_sketch_union_combine,
@@ -146,7 +146,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_intersection(aod_sketch) (
+CREATE OR REPLACE AGGREGATE aod_sketch_intersection(aod_sketch) (
STYPE = internal,
SFUNC = aod_sketch_intersection_agg,
COMBINEFUNC = aod_sketch_intersection_combine,
@@ -156,7 +156,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE aod_sketch_intersection(aod_sketch, int) (
+CREATE OR REPLACE AGGREGATE aod_sketch_intersection(aod_sketch, int) (
STYPE = internal,
SFUNC = aod_sketch_intersection_agg,
COMBINEFUNC = aod_sketch_intersection_combine,
diff --git a/sql/datasketches_cpc_sketch.sql b/sql/datasketches_cpc_sketch.sql
index e506e34..d3435bd 100644
--- a/sql/datasketches_cpc_sketch.sql
+++ b/sql/datasketches_cpc_sketch.sql
@@ -70,7 +70,7 @@
AS '$libdir/datasketches', 'pg_cpc_sketch_deserialize_state'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE cpc_sketch_distinct(anyelement) (
+CREATE OR REPLACE AGGREGATE cpc_sketch_distinct(anyelement) (
STYPE = internal,
SFUNC = cpc_sketch_build_agg,
COMBINEFUNC = cpc_sketch_combine,
@@ -80,7 +80,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE cpc_sketch_distinct(anyelement, int) (
+CREATE OR REPLACE AGGREGATE cpc_sketch_distinct(anyelement, int) (
STYPE = internal,
SFUNC = cpc_sketch_build_agg,
COMBINEFUNC = cpc_sketch_combine,
@@ -90,7 +90,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE cpc_sketch_build(anyelement) (
+CREATE OR REPLACE AGGREGATE cpc_sketch_build(anyelement) (
STYPE = internal,
SFUNC = cpc_sketch_build_agg,
COMBINEFUNC = cpc_sketch_combine,
@@ -100,7 +100,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE cpc_sketch_build(anyelement, int) (
+CREATE OR REPLACE AGGREGATE cpc_sketch_build(anyelement, int) (
STYPE = internal,
SFUNC = cpc_sketch_build_agg,
COMBINEFUNC = cpc_sketch_combine,
@@ -110,7 +110,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE cpc_sketch_union(cpc_sketch) (
+CREATE OR REPLACE AGGREGATE cpc_sketch_union(cpc_sketch) (
STYPE = internal,
SFUNC = cpc_sketch_union_agg,
COMBINEFUNC = cpc_sketch_combine,
@@ -120,7 +120,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE cpc_sketch_union(cpc_sketch, int) (
+CREATE OR REPLACE AGGREGATE cpc_sketch_union(cpc_sketch, int) (
STYPE = internal,
SFUNC = cpc_sketch_union_agg,
COMBINEFUNC = cpc_sketch_combine,
diff --git a/sql/datasketches_frequent_strings_sketch.sql b/sql/datasketches_frequent_strings_sketch.sql
index 22bb487..b84056a 100644
--- a/sql/datasketches_frequent_strings_sketch.sql
+++ b/sql/datasketches_frequent_strings_sketch.sql
@@ -62,7 +62,7 @@
AS '$libdir/datasketches', 'pg_frequent_strings_sketch_serialize'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE frequent_strings_sketch_build(int, varchar) (
+CREATE OR REPLACE AGGREGATE frequent_strings_sketch_build(int, varchar) (
STYPE = internal,
SFUNC = frequent_strings_sketch_build_agg,
COMBINEFUNC = frequent_strings_sketch_combine,
@@ -72,7 +72,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE frequent_strings_sketch_build(int, varchar, bigint) (
+CREATE OR REPLACE AGGREGATE frequent_strings_sketch_build(int, varchar, bigint) (
STYPE = internal,
SFUNC = frequent_strings_sketch_build_agg,
COMBINEFUNC = frequent_strings_sketch_combine,
@@ -82,7 +82,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE frequent_strings_sketch_merge(int, frequent_strings_sketch) (
+CREATE OR REPLACE AGGREGATE frequent_strings_sketch_merge(int, frequent_strings_sketch) (
STYPE = internal,
SFUNC = frequent_strings_sketch_merge_agg,
COMBINEFUNC = frequent_strings_sketch_combine,
diff --git a/sql/datasketches_hll_sketch.sql b/sql/datasketches_hll_sketch.sql
index f8c4a64..36e40d9 100644
--- a/sql/datasketches_hll_sketch.sql
+++ b/sql/datasketches_hll_sketch.sql
@@ -78,7 +78,7 @@
AS '$libdir/datasketches', 'pg_hll_sketch_deserialize_state'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE hll_sketch_distinct(anyelement) (
+CREATE OR REPLACE AGGREGATE hll_sketch_distinct(anyelement) (
STYPE = internal,
SFUNC = hll_sketch_build_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -88,7 +88,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_distinct(anyelement, int) (
+CREATE OR REPLACE AGGREGATE hll_sketch_distinct(anyelement, int) (
STYPE = internal,
SFUNC = hll_sketch_build_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -98,7 +98,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_build(anyelement) (
+CREATE OR REPLACE AGGREGATE hll_sketch_build(anyelement) (
STYPE = internal,
SFUNC = hll_sketch_build_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -108,7 +108,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_build(anyelement, int) (
+CREATE OR REPLACE AGGREGATE hll_sketch_build(anyelement, int) (
STYPE = internal,
SFUNC = hll_sketch_build_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -118,7 +118,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_build(anyelement, int, int) (
+CREATE OR REPLACE AGGREGATE hll_sketch_build(anyelement, int, int) (
STYPE = internal,
SFUNC = hll_sketch_build_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -128,7 +128,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_union(hll_sketch) (
+CREATE OR REPLACE AGGREGATE hll_sketch_union(hll_sketch) (
STYPE = internal,
SFUNC = hll_sketch_union_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -138,7 +138,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_union(hll_sketch, int) (
+CREATE OR REPLACE AGGREGATE hll_sketch_union(hll_sketch, int) (
STYPE = internal,
SFUNC = hll_sketch_union_agg,
COMBINEFUNC = hll_sketch_combine,
@@ -148,7 +148,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE hll_sketch_union(hll_sketch, int, int) (
+CREATE OR REPLACE AGGREGATE hll_sketch_union(hll_sketch, int, int) (
STYPE = internal,
SFUNC = hll_sketch_union_agg,
COMBINEFUNC = hll_sketch_combine,
diff --git a/sql/datasketches_kll_double_sketch.sql b/sql/datasketches_kll_double_sketch.sql
index 630143d..13100f6 100644
--- a/sql/datasketches_kll_double_sketch.sql
+++ b/sql/datasketches_kll_double_sketch.sql
@@ -66,7 +66,7 @@
AS '$libdir/datasketches', 'pg_kll_double_sketch_serialize'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE kll_double_sketch_build(double precision) (
+CREATE OR REPLACE AGGREGATE kll_double_sketch_build(double precision) (
STYPE = internal,
SFUNC = kll_double_sketch_build_agg,
COMBINEFUNC = kll_double_sketch_combine,
@@ -76,7 +76,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE kll_double_sketch_build(double precision, int) (
+CREATE OR REPLACE AGGREGATE kll_double_sketch_build(double precision, int) (
STYPE = internal,
SFUNC = kll_double_sketch_build_agg,
COMBINEFUNC = kll_double_sketch_combine,
@@ -86,7 +86,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE kll_double_sketch_merge(kll_double_sketch) (
+CREATE OR REPLACE AGGREGATE kll_double_sketch_merge(kll_double_sketch) (
STYPE = internal,
SFUNC = kll_double_sketch_merge_agg,
COMBINEFUNC = kll_double_sketch_combine,
@@ -96,7 +96,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE kll_double_sketch_merge(kll_double_sketch, int) (
+CREATE OR REPLACE AGGREGATE kll_double_sketch_merge(kll_double_sketch, int) (
STYPE = internal,
SFUNC = kll_double_sketch_merge_agg,
COMBINEFUNC = kll_double_sketch_combine,
diff --git a/sql/datasketches_kll_float_sketch.sql b/sql/datasketches_kll_float_sketch.sql
index 426b16b..84126d2 100644
--- a/sql/datasketches_kll_float_sketch.sql
+++ b/sql/datasketches_kll_float_sketch.sql
@@ -66,7 +66,7 @@
AS '$libdir/datasketches', 'pg_kll_float_sketch_serialize'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE kll_float_sketch_build(real) (
+CREATE OR REPLACE AGGREGATE kll_float_sketch_build(real) (
STYPE = internal,
SFUNC = kll_float_sketch_build_agg,
COMBINEFUNC = kll_float_sketch_combine,
@@ -76,7 +76,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE kll_float_sketch_build(real, int) (
+CREATE OR REPLACE AGGREGATE kll_float_sketch_build(real, int) (
STYPE = internal,
SFUNC = kll_float_sketch_build_agg,
COMBINEFUNC = kll_float_sketch_combine,
@@ -86,7 +86,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE kll_float_sketch_merge(kll_float_sketch) (
+CREATE OR REPLACE AGGREGATE kll_float_sketch_merge(kll_float_sketch) (
STYPE = internal,
SFUNC = kll_float_sketch_merge_agg,
COMBINEFUNC = kll_float_sketch_combine,
@@ -96,7 +96,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE kll_float_sketch_merge(kll_float_sketch, int) (
+CREATE OR REPLACE AGGREGATE kll_float_sketch_merge(kll_float_sketch, int) (
STYPE = internal,
SFUNC = kll_float_sketch_merge_agg,
COMBINEFUNC = kll_float_sketch_combine,
diff --git a/sql/datasketches_quantiles_double_sketch.sql b/sql/datasketches_quantiles_double_sketch.sql
index f1f334c..648c752 100644
--- a/sql/datasketches_quantiles_double_sketch.sql
+++ b/sql/datasketches_quantiles_double_sketch.sql
@@ -66,7 +66,7 @@
AS '$libdir/datasketches', 'pg_quantiles_double_sketch_serialize'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE quantiles_double_sketch_build(double precision) (
+CREATE OR REPLACE AGGREGATE quantiles_double_sketch_build(double precision) (
STYPE = internal,
SFUNC = quantiles_double_sketch_build_agg,
COMBINEFUNC = quantiles_double_sketch_combine,
@@ -76,7 +76,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE quantiles_double_sketch_build(double precision, int) (
+CREATE OR REPLACE AGGREGATE quantiles_double_sketch_build(double precision, int) (
STYPE = internal,
SFUNC = quantiles_double_sketch_build_agg,
COMBINEFUNC = quantiles_double_sketch_combine,
@@ -86,7 +86,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE quantiles_double_sketch_merge(quantiles_double_sketch) (
+CREATE OR REPLACE AGGREGATE quantiles_double_sketch_merge(quantiles_double_sketch) (
STYPE = internal,
SFUNC = quantiles_double_sketch_merge_agg,
COMBINEFUNC = quantiles_double_sketch_combine,
@@ -96,7 +96,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE quantiles_double_sketch_merge(quantiles_double_sketch, int) (
+CREATE OR REPLACE AGGREGATE quantiles_double_sketch_merge(quantiles_double_sketch, int) (
STYPE = internal,
SFUNC = quantiles_double_sketch_merge_agg,
COMBINEFUNC = quantiles_double_sketch_combine,
diff --git a/sql/datasketches_req_float_sketch.sql b/sql/datasketches_req_float_sketch.sql
index 3bf056c..f3066ad 100644
--- a/sql/datasketches_req_float_sketch.sql
+++ b/sql/datasketches_req_float_sketch.sql
@@ -74,7 +74,7 @@
AS '$libdir/datasketches', 'pg_req_float_sketch_serialize'
LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;
-CREATE AGGREGATE req_float_sketch_build(real) (
+CREATE OR REPLACE AGGREGATE req_float_sketch_build(real) (
STYPE = internal,
SFUNC = req_float_sketch_build_agg,
COMBINEFUNC = req_float_sketch_combine,
@@ -84,7 +84,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE req_float_sketch_build(real, int) (
+CREATE OR REPLACE AGGREGATE req_float_sketch_build(real, int) (
STYPE = internal,
SFUNC = req_float_sketch_build_agg,
COMBINEFUNC = req_float_sketch_combine,
@@ -94,7 +94,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE req_float_sketch_build(real, int, boolean) (
+CREATE OR REPLACE AGGREGATE req_float_sketch_build(real, int, boolean) (
STYPE = internal,
SFUNC = req_float_sketch_build_agg,
COMBINEFUNC = req_float_sketch_combine,
@@ -104,7 +104,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE req_float_sketch_merge(req_float_sketch) (
+CREATE OR REPLACE AGGREGATE req_float_sketch_merge(req_float_sketch) (
STYPE = internal,
SFUNC = req_float_sketch_merge_agg,
COMBINEFUNC = req_float_sketch_combine,
@@ -114,7 +114,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE req_float_sketch_merge(req_float_sketch, int) (
+CREATE OR REPLACE AGGREGATE req_float_sketch_merge(req_float_sketch, int) (
STYPE = internal,
SFUNC = req_float_sketch_merge_agg,
COMBINEFUNC = req_float_sketch_combine,
@@ -124,7 +124,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE req_float_sketch_merge(req_float_sketch, int, boolean) (
+CREATE OR REPLACE AGGREGATE req_float_sketch_merge(req_float_sketch, int, boolean) (
STYPE = internal,
SFUNC = req_float_sketch_merge_agg,
COMBINEFUNC = req_float_sketch_combine,
diff --git a/sql/datasketches_theta_sketch.sql b/sql/datasketches_theta_sketch.sql
index bd5ca11..f4efc16 100644
--- a/sql/datasketches_theta_sketch.sql
+++ b/sql/datasketches_theta_sketch.sql
@@ -102,7 +102,7 @@
PARALLEL = SAFE
);
-CREATE AGGREGATE theta_sketch_build(anyelement) (
+CREATE OR REPLACE AGGREGATE theta_sketch_build(anyelement) (
STYPE = internal,
SFUNC = theta_sketch_build_agg,
COMBINEFUNC = theta_sketch_union_combine,
