You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@age.apache.org by jg...@apache.org on 2022/03/04 23:05:54 UTC
[incubator-age] branch master updated: Add upgrading file age--0.7.0--1.0.0.sql (#191)
This is an automated email from the ASF dual-hosted git repository.
jgemignani pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-age.git
The following commit(s) were added to refs/heads/master by this push:
new 8b43886 Add upgrading file age--0.7.0--1.0.0.sql (#191)
8b43886 is described below
commit 8b438860cd9007db2531a7d449438a03ca75b1bd
Author: Quoc Viet Vuong <qu...@gmail.com>
AuthorDate: Sat Mar 5 06:05:49 2022 +0700
Add upgrading file age--0.7.0--1.0.0.sql (#191)
Add upgrading file age--0.6.0--0.7.0.sql
---
age--0.6.0--0.7.0.sql | 181 ++++++++++++++++++++++++++++++++++++++++++++++++++
age--0.7.0--1.0.0.sql | 30 +++++++++
2 files changed, 211 insertions(+)
diff --git a/age--0.6.0--0.7.0.sql b/age--0.6.0--0.7.0.sql
new file mode 100644
index 0000000..518ae1a
--- /dev/null
+++ b/age--0.6.0--0.7.0.sql
@@ -0,0 +1,181 @@
+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
+\echo Use "ALTER EXTENSION age UPDATE TO '0.7.0'" to load this file. \quit
+
+CREATE FUNCTION ag_catalog.create_vlabel(graph_name name, label_name name)
+ RETURNS void
+ LANGUAGE c
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.create_elabel(graph_name name, label_name name)
+ RETURNS void
+ LANGUAGE c
+AS 'MODULE_PATHNAME';
+
+-- binary I/O functions
+CREATE FUNCTION ag_catalog.graphid_send(graphid)
+RETURNS bytea
+LANGUAGE c
+IMMUTABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.graphid_recv(internal)
+RETURNS graphid
+LANGUAGE c
+IMMUTABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+UPDATE pg_type SET
+typsend = 'ag_catalog.graphid_send',
+typreceive = 'ag_catalog.graphid_recv'
+WHERE typname = 'graphid';
+
+-- binary I/O functions
+CREATE FUNCTION ag_catalog.agtype_send(agtype)
+RETURNS bytea
+LANGUAGE c
+IMMUTABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.agtype_recv(internal)
+RETURNS agtype
+LANGUAGE c
+IMMUTABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+UPDATE pg_type SET
+typsend = 'ag_catalog.agtype_send',
+typreceive = 'ag_catalog.agtype_recv'
+WHERE typname = 'agtype';
+
+-- agtype -> int4[]
+CREATE FUNCTION ag_catalog.agtype_to_int4_array(variadic "any")
+ RETURNS int[]
+ LANGUAGE c
+ STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE CAST (agtype AS int[])
+ WITH FUNCTION ag_catalog.agtype_to_int4_array(variadic "any");
+
+CREATE FUNCTION ag_catalog.age_eq_tilde(agtype, agtype)
+RETURNS agtype
+LANGUAGE c
+STABLE
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE OR REPLACE FUNCTION ag_catalog.age_vle(IN agtype, IN agtype, IN agtype, IN agtype,
+ IN agtype, IN agtype, IN agtype,
+ OUT edges agtype)
+RETURNS SETOF agtype
+LANGUAGE C
+STABLE
+CALLED ON NULL INPUT
+PARALLEL UNSAFE -- might be safe
+AS 'MODULE_PATHNAME';
+
+-- function to build an edge for a VLE match
+CREATE FUNCTION ag_catalog.age_build_vle_match_edge(agtype, agtype)
+RETURNS agtype
+LANGUAGE C
+STABLE
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+-- function to match a terminal vle edge
+CREATE FUNCTION ag_catalog.age_match_vle_terminal_edge(agtype, agtype, agtype)
+RETURNS boolean
+LANGUAGE C
+STABLE
+CALLED ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+
+-- function to create an AGTV_PATH from a VLE_path_container
+CREATE FUNCTION ag_catalog.age_materialize_vle_path(agtype)
+RETURNS agtype
+LANGUAGE C
+STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+-- function to create an AGTV_ARRAY of edges from a VLE_path_container
+CREATE FUNCTION ag_catalog.age_materialize_vle_edges(agtype)
+RETURNS agtype
+LANGUAGE C
+STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.age_match_vle_edge_to_id_qual(agtype, agtype, agtype)
+RETURNS boolean
+LANGUAGE C
+STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+
+CREATE FUNCTION ag_catalog.age_match_two_vle_edges(agtype, agtype)
+RETURNS boolean
+LANGUAGE C
+STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+-- list functions
+CREATE FUNCTION ag_catalog.age_keys(agtype)
+RETURNS agtype
+LANGUAGE c
+STABLE
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.age_labels(agtype)
+RETURNS agtype
+LANGUAGE c
+STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.age_nodes(agtype)
+RETURNS agtype
+LANGUAGE c
+STABLE
+RETURNS NULL ON NULL INPUT
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.age_relationships(agtype)
+RETURNS agtype
+LANGUAGE c
+STABLE
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.age_range(variadic "any")
+RETURNS agtype
+LANGUAGE c
+STABLE
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+
+--
+-- End
+--
+
diff --git a/age--0.7.0--1.0.0.sql b/age--0.7.0--1.0.0.sql
new file mode 100644
index 0000000..cff34c0
--- /dev/null
+++ b/age--0.7.0--1.0.0.sql
@@ -0,0 +1,30 @@
+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
+\echo Use "ALTER EXTENSION age UPDATE TO '1.0.0'" to load this file. \quit
+
+CREATE FUNCTION ag_catalog.load_labels_from_file(graph_name name,
+ label_name name,
+ file_path text,
+ id_field_exists bool default true)
+ RETURNS void
+ LANGUAGE c
+ AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.load_edges_from_file(graph_name name,
+ label_name name,
+ file_path text)
+ RETURNS void
+ LANGUAGE c
+ AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog._cypher_merge_clause(internal)
+RETURNS void
+LANGUAGE c
+AS 'MODULE_PATHNAME';
+
+CREATE FUNCTION ag_catalog.age_unnest(agtype, block_types boolean = false)
+ RETURNS SETOF agtype
+ LANGUAGE c
+ STABLE
+PARALLEL SAFE
+AS 'MODULE_PATHNAME';
+