neopostgraph--0.1.0.sql

/*
 * PostGraph
 * Copyright (C) 2026 by PostGraph
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 */

 -- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION NeoPostGraph" to load this file. \quit

--
-- catalog tables
--

--
-- Graph Metadata
--
CREATE TABLE np_graph (id int NOT NULL, name name NOT NULL, namespace regnamespace NOT NULL, vertex_id_seq regclass NOT NULL);

CREATE SEQUENCE np_graph_id_seq START WITH 1 INCREMENT BY 1 MINVALUE 1 CACHE 5;

ALTER SEQUENCE np_graph_id_seq OWNED BY np_graph.id;

ALTER TABLE ONLY np_graph ALTER COLUMN id SET DEFAULT nextval('np_graph_id_seq'::regclass);

-- Indexes for np_graph
CREATE UNIQUE INDEX np_graph_name_namespace_index ON np_graph USING btree (name, namespace);

CREATE FUNCTION create_graph(graph_name Name, namespace text DEFAULT NULL)
RETURNS void 
LANGUAGE c 
AS 'MODULE_PATHNAME';

--
-- Vertex Label Metadata
--
CREATE TABLE np_vertex_label (id int NOT NULL, graph_id int NOT NULL, label public.ltree NOT NULL);

-- Indexes for np_vertex_label
CREATE UNIQUE INDEX np_vertex_label_graph_id_id_index ON np_vertex_label USING btree (graph_id, id);
CREATE INDEX np_vertex_label_graph_id_label ON np_vertex_label USING GIST (graph_id, label public.gist_ltree_ops);

CREATE FUNCTION create_vlabel(graph_name Name, label public.ltree, namespace text DEFAULT NULL)
RETURNS void 
LANGUAGE c 
AS 'MODULE_PATHNAME';

CREATE FUNCTION get_vlabel_ids(graph_name name, labels text[], namespace_name text DEFAULT NULL)
RETURNS SETOF int
AS 'MODULE_PATHNAME', 'get_vlabel_ids_by_path'
LANGUAGE C STABLE;

CREATE FUNCTION get_or_vlabel_ids(graph_name name, labels text[], namespace_name text DEFAULT NULL)
RETURNS SETOF int
AS 'MODULE_PATHNAME', 'get_or_vlabel_ids_by_path'
LANGUAGE C STABLE;