Changeset: 8f033ee06097 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8f033ee06097
Modified Files:
sql/scripts/40_json.sql
sql/scripts/Makefile.ag
Branch: default
Log Message:
Make json initialization script available
The functions await implementation of the
CREATE TYPE myt AS TABLE(...)
and its use in functions.
diffs (55 lines):
diff --git a/sql/scripts/40_json.sql b/sql/scripts/40_json.sql
--- a/sql/scripts/40_json.sql
+++ b/sql/scripts/40_json.sql
@@ -41,15 +41,31 @@ returns bool external name json.isvalida
create function json_length(js json)
returns integer external name json.length;
+-- The remainder awaits the implementation of
+-- proper functions with table type arguments.
+
-- unnesting the JSON structure
-create function json_names(js json)
-returns table ( nme string) external name json.names;
-create function json_values(js json)
-returns table ( val string) external name json."values";
+-- create function json_unnest(js json)
+-- returns table( id integer, k string, v string) external name json.unnest;
+
+-- create function json_unnest(js json)
+-- returns table( k string, v string) external name json.unnest;
+
+-- create function json_unnest(js json)
+-- returns table( v string) external name json.unnest;
+
+-- create function json_nest table( id integer, k string, v string)
+-- returns json external name json.nest;
+
+-- create function json_names(js json)
+-- returns table ( nme string) external name json.names;
+
+-- create function json_values(js json)
+-- returns table ( val string) external name json."values";
-- rendering functions
-create function json_object(*)
-returns json external name json.objectrender;
-create function json_array(*)
-returns json external name json.arrayrender;
+-- create function json_object(*)
+-- returns json external name json.objectrender;
+-- create function json_array(*)
+-- returns json external name json.arrayrender;
diff --git a/sql/scripts/Makefile.ag b/sql/scripts/Makefile.ag
--- a/sql/scripts/Makefile.ag
+++ b/sql/scripts/Makefile.ag
@@ -20,7 +20,7 @@ MT_SAFE
headers_sql = {
HEADERS = sql
DIR = libdir/monetdb5/createdb
- SOURCES = 09_like.sql 10_math.sql 11_times.sql 12_url.sql 13_date.sql
14_inet.sql 15_querylog.sql 16_tracelog.sql 17_compress.sql 18_dictionary.sql
19_cluster.sql 20_vacuum.sql 21_dependency_functions.sql 22_clients.sql
23_skyserver.sql 24_zorder.sql 25_debug.sql 26_sysmon.sql 39_analytics.sql
75_storagemodel.sql 99_system.sql
+ SOURCES = 09_like.sql 10_math.sql 11_times.sql 12_url.sql 13_date.sql
14_inet.sql 15_querylog.sql 16_tracelog.sql 17_compress.sql 18_dictionary.sql
19_cluster.sql 20_vacuum.sql 21_dependency_functions.sql 22_clients.sql
23_skyserver.sql 24_zorder.sql 25_debug.sql 26_sysmon.sql 39_analytics.sql
40_json.sql 75_storagemodel.sql 99_system.sql
}
headers_moresql = {
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
