From 1262a713db60c1f9404c2b30fcc477a0c7217bae Mon Sep 17 00:00:00 2001
From: glyn <glyn@8kb.co.uk>
Date: Tue, 27 Jan 2015 21:04:31 +0000
Subject: [PATCH] Rename misspelt sql script

---
 jsonb_opxi_sql_comparison.sql | 59 -----------------------------------
 1 file changed, 59 deletions(-)
 delete mode 100755 jsonb_opxi_sql_comparison.sql

diff --git a/jsonb_opxi_sql_comparison.sql b/jsonb_opxi_sql_comparison.sql
deleted file mode 100755
index 4bfebf6..0000000
--- a/jsonb_opxi_sql_comparison.sql
+++ /dev/null
@@ -1,59 +0,0 @@
--- The functions in this script are SQL versions of the C ones for comparison
--- of performance between the two.
-
-CREATE OR REPLACE FUNCTION jsonb_delete_left(a jsonb, b text)
-RETURNS jsonb AS
-$BODY$
-SELECT COALESCE(
-(
-SELECT ('{' || string_agg(to_json(key) || ':' || value, ',') || '}')
-FROM jsonb_each(a)
-WHERE key <> b
-)
-, '{}')::jsonb;
-$BODY$
-LANGUAGE sql IMMUTABLE STRICT;
-
---
-
-CREATE OR REPLACE FUNCTION jsonb_delete_left(a jsonb, b text[])
-RETURNS jsonb AS
-$BODY$
-SELECT COALESCE(
-(
-SELECT ('{' || string_agg(to_json(key) || ':' || value, ',') || '}')
-FROM jsonb_each(a)
-WHERE key <> ALL(b)
-)
-, '{}')::jsonb;
-$BODY$
-LANGUAGE sql IMMUTABLE STRICT;
-
---
-
-CREATE OR REPLACE FUNCTION jsonb_delete_left(a jsonb, b jsonb)
-RETURNS jsonb AS
-$BODY$
-SELECT COALESCE(
-(
-SELECT ('{' || string_agg(to_json(key) || ':' || value, ',') || '}')
-FROM jsonb_each(a)
-WHERE NOT ('{' || to_json(key) || ':' || value || '}')::jsonb <@ b
-)
-, '{}')::jsonb;
-$BODY$
-LANGUAGE sql IMMUTABLE STRICT;
-
---
-
-CREATE OR REPLACE FUNCTION jsonb_concat_left (a jsonb, b jsonb) 
-RETURNS jsonb AS
-$BODY$
-SELECT json_object_agg(key, value)::jsonb FROM
-(
-  SELECT * FROM jsonb_each(a)
-  UNION ALL
-  SELECT * FROM jsonb_each(b)
-) a;
-$BODY$
-LANGUAGE sql IMMUTABLE STRICT; 
-- 
2.39.2