| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| |
| -- complain if script is sourced in psql, rather than via CREATE EXTENSION |
| \echo Use "CREATE EXTENSION age" to load this file. \quit |
| |
| -- |
| -- catalog tables |
| -- |
| |
| CREATE TABLE ag_graph ( |
| name name NOT NULL, |
| namespace regnamespace NOT NULL |
| ) WITH (OIDS); |
| |
| -- include content of the ag_graph table into the pg_dump output |
| SELECT pg_catalog.pg_extension_config_dump('ag_graph', ''); |
| |
| CREATE UNIQUE INDEX ag_graph_oid_index ON ag_graph USING btree (oid); |
| |
| CREATE UNIQUE INDEX ag_graph_name_index ON ag_graph USING btree (name); |
| |
| CREATE UNIQUE INDEX ag_graph_namespace_index |
| ON ag_graph |
| USING btree (namespace); |
| |
| -- 0 is an invalid label ID |
| CREATE DOMAIN label_id AS int NOT NULL CHECK (VALUE > 0 AND VALUE <= 65535); |
| |
| CREATE DOMAIN label_kind AS "char" NOT NULL CHECK (VALUE = 'v' OR VALUE = 'e'); |
| |
| CREATE TABLE ag_label ( |
| name name NOT NULL, |
| graph oid NOT NULL, |
| id label_id, |
| kind label_kind, |
| relation regclass NOT NULL, |
| seq_name name NOT NULL |
| ) WITH (OIDS); |
| |
| -- include content of the ag_label table into the pg_dump output |
| SELECT pg_catalog.pg_extension_config_dump('ag_label', ''); |
| |
| CREATE UNIQUE INDEX ag_label_oid_index ON ag_label USING btree (oid); |
| |
| CREATE UNIQUE INDEX ag_label_name_graph_index |
| ON ag_label |
| USING btree (name, graph); |
| |
| CREATE UNIQUE INDEX ag_label_graph_id_index |
| ON ag_label |
| USING btree (graph, id); |
| |
| CREATE UNIQUE INDEX ag_label_relation_index ON ag_label USING btree (relation); |
| |
| CREATE UNIQUE INDEX ag_label_seq_name_graph_index |
| ON ag_label |
| USING btree (seq_name, graph); |
| -- |
| -- catalog lookup functions |
| -- |
| |
| CREATE FUNCTION ag_catalog._label_id(graph_name name, label_name name) |
| RETURNS label_id |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- utility functions |
| -- |
| |
| CREATE FUNCTION ag_catalog.create_graph(graph_name name) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.drop_graph(graph_name name, cascade boolean = false) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| 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'; |
| |
| CREATE FUNCTION ag_catalog.alter_graph(graph_name name, operation cstring, new_value name) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.drop_label(graph_name name, label_name name, |
| force boolean = false) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| 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'; |
| |
| -- |
| -- graphid type |
| -- |
| |
| -- define graphid as a shell type first |
| CREATE TYPE graphid; |
| |
| CREATE FUNCTION ag_catalog.graphid_in(cstring) |
| RETURNS graphid |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.graphid_out(graphid) |
| RETURNS cstring |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| 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'; |
| |
| CREATE TYPE graphid ( |
| INPUT = ag_catalog.graphid_in, |
| OUTPUT = ag_catalog.graphid_out, |
| SEND = ag_catalog.graphid_send, |
| RECEIVE = ag_catalog.graphid_recv, |
| INTERNALLENGTH = 8, |
| PASSEDBYVALUE, |
| ALIGNMENT = float8, |
| STORAGE = plain |
| ); |
| |
| -- |
| -- graphid - comparison operators (=, <>, <, >, <=, >=) |
| -- |
| |
| CREATE FUNCTION ag_catalog.graphid_eq(graphid, graphid) |
| RETURNS boolean |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.graphid_eq, |
| LEFTARG = graphid, |
| RIGHTARG = graphid, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel, |
| HASHES, |
| MERGES |
| ); |
| |
| CREATE FUNCTION ag_catalog.graphid_ne(graphid, graphid) |
| RETURNS boolean |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.graphid_ne, |
| LEFTARG = graphid, |
| RIGHTARG = graphid, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.graphid_lt(graphid, graphid) |
| RETURNS boolean |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.graphid_lt, |
| LEFTARG = graphid, |
| RIGHTARG = graphid, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.graphid_gt(graphid, graphid) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.graphid_gt, |
| LEFTARG = graphid, |
| RIGHTARG = graphid, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.graphid_le(graphid, graphid) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.graphid_le, |
| LEFTARG = graphid, |
| RIGHTARG = graphid, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.graphid_ge(graphid, graphid) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.graphid_ge, |
| LEFTARG = graphid, |
| RIGHTARG = graphid, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| -- |
| -- graphid - B-tree support functions |
| -- |
| |
| -- comparison support |
| CREATE FUNCTION ag_catalog.graphid_btree_cmp(graphid, graphid) |
| RETURNS int |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- sort support |
| CREATE FUNCTION ag_catalog.graphid_btree_sort(internal) |
| RETURNS void |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- define operator classes for graphid |
| -- |
| |
| -- B-tree strategies |
| -- 1: less than |
| -- 2: less than or equal |
| -- 3: equal |
| -- 4: greater than or equal |
| -- 5: greater than |
| -- |
| -- B-tree support functions |
| -- 1: compare two keys and return an integer less than zero, zero, or greater |
| -- than zero, indicating whether the first key is less than, equal to, or |
| -- greater than the second |
| -- 2: return the addresses of C-callable sort support function(s) (optional) |
| -- 3: compare a test value to a base value plus/minus an offset, and return |
| -- true or false according to the comparison result (optional) |
| CREATE OPERATOR CLASS graphid_ops DEFAULT FOR TYPE graphid USING btree AS |
| OPERATOR 1 <, |
| OPERATOR 2 <=, |
| OPERATOR 3 =, |
| OPERATOR 4 >=, |
| OPERATOR 5 >, |
| FUNCTION 1 ag_catalog.graphid_btree_cmp (graphid, graphid), |
| FUNCTION 2 ag_catalog.graphid_btree_sort (internal); |
| |
| -- |
| -- graphid functions |
| -- |
| |
| CREATE FUNCTION ag_catalog._graphid(label_id int, entry_id bigint) |
| RETURNS graphid |
| LANGUAGE c |
| IMMUTABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog._label_name(graph_oid oid, graphid) |
| RETURNS cstring |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog._extract_label_id(graphid) |
| RETURNS label_id |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- agtype type and its support functions |
| -- |
| |
| -- define agtype as a shell type first |
| CREATE TYPE agtype; |
| |
| CREATE FUNCTION ag_catalog.agtype_in(cstring) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_out(agtype) |
| RETURNS cstring |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- 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'; |
| |
| CREATE TYPE agtype ( |
| INPUT = ag_catalog.agtype_in, |
| OUTPUT = ag_catalog.agtype_out, |
| SEND = ag_catalog.agtype_send, |
| RECEIVE = ag_catalog.agtype_recv, |
| LIKE = jsonb |
| ); |
| |
| -- |
| -- agtype - mathematical operators (+, -, *, /, %, ^) |
| -- |
| |
| CREATE FUNCTION ag_catalog.agtype_add(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_add, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(agtype, smallint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(smallint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(agtype, integer) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(integer, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(agtype, bigint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(bigint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(agtype, real) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(real, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(agtype, double precision) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(double precision, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(agtype, numeric) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_add(numeric, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR + ( |
| FUNCTION = ag_catalog.agtype_any_add, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = + |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_sub(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_sub, |
| LEFTARG = agtype, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(agtype, smallint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = agtype, |
| RIGHTARG = smallint |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(smallint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = smallint, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(agtype, integer) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = agtype, |
| RIGHTARG = integer |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(integer, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = integer, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(agtype, bigint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = agtype, |
| RIGHTARG = bigint |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(bigint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = bigint, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(agtype, real) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = agtype, |
| RIGHTARG = real |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(real, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = real, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(agtype, double precision) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = agtype, |
| RIGHTARG = double precision |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(double precision, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = double precision, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(agtype, numeric) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = agtype, |
| RIGHTARG = numeric |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_sub(numeric, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_any_sub, |
| LEFTARG = numeric, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_neg(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR - ( |
| FUNCTION = ag_catalog.agtype_neg, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_mul(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_mul, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(agtype, smallint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(smallint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(agtype, integer) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(integer, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(agtype, bigint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(bigint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(agtype, real) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(real, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(agtype, double precision) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(double precision, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(agtype, numeric) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mul(numeric, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR * ( |
| FUNCTION = ag_catalog.agtype_any_mul, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = * |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_div(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_div, |
| LEFTARG = agtype, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(agtype, smallint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = agtype, |
| RIGHTARG = smallint |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(smallint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = smallint, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(agtype, integer) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = agtype, |
| RIGHTARG = integer |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(integer, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = integer, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(agtype, bigint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = agtype, |
| RIGHTARG = bigint |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(bigint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = bigint, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(agtype, real) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = agtype, |
| RIGHTARG = real |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(real, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = real, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(agtype, double precision) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = agtype, |
| RIGHTARG = double precision |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(double precision, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = double precision, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(agtype, numeric) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = agtype, |
| RIGHTARG = numeric |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_div(numeric, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR / ( |
| FUNCTION = ag_catalog.agtype_any_div, |
| LEFTARG = numeric, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_mod(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_mod, |
| LEFTARG = agtype, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(agtype, smallint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = agtype, |
| RIGHTARG = smallint |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(smallint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = smallint, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(agtype, integer) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = agtype, |
| RIGHTARG = integer |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(integer, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = integer, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(agtype, bigint) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = agtype, |
| RIGHTARG = bigint |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(bigint, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = bigint, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(agtype, real) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = agtype, |
| RIGHTARG = real |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(real, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = real, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(agtype, double precision) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = agtype, |
| RIGHTARG = double precision |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(double precision, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = double precision, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(agtype, numeric) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = agtype, |
| RIGHTARG = numeric |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_mod(numeric, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR % ( |
| FUNCTION = ag_catalog.agtype_any_mod, |
| LEFTARG = numeric, |
| RIGHTARG = agtype |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_pow(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR ^ ( |
| FUNCTION = ag_catalog.agtype_pow, |
| LEFTARG = agtype, |
| RIGHTARG = agtype |
| ); |
| |
| |
| CREATE FUNCTION ag_catalog.graphid_hash_cmp(graphid) |
| RETURNS INTEGER |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR CLASS graphid_ops_hash |
| DEFAULT |
| FOR TYPE graphid |
| USING hash AS |
| OPERATOR 1 =, |
| FUNCTION 1 ag_catalog.graphid_hash_cmp(graphid); |
| |
| -- |
| -- agtype - comparison operators (=, <>, <, >, <=, >=) |
| -- |
| |
| CREATE FUNCTION ag_catalog.agtype_eq(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_eq, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel, |
| HASHES |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(agtype, smallint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(smallint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(agtype, integer) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(integer, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(agtype, bigint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(bigint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(agtype, real) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(real, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(agtype, double precision) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(double precision, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(agtype, numeric) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_eq(numeric, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR = ( |
| FUNCTION = ag_catalog.agtype_any_eq, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = =, |
| NEGATOR = <>, |
| RESTRICT = eqsel, |
| JOIN = eqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_ne(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_ne, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(agtype, smallint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(smallint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(agtype, integer) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(integer, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(agtype, bigint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(bigint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(agtype, real) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(real, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(agtype, double precision) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(double precision, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(agtype, numeric) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ne(numeric, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <> ( |
| FUNCTION = ag_catalog.agtype_any_ne, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = <>, |
| NEGATOR = =, |
| RESTRICT = neqsel, |
| JOIN = neqjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_lt(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_lt, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(agtype, smallint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(smallint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(agtype, integer) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(integer, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(agtype, bigint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(bigint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(agtype, real) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(real, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(agtype, double precision) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(double precision, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(agtype, numeric) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_lt(numeric, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR < ( |
| FUNCTION = ag_catalog.agtype_any_lt, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = >, |
| NEGATOR = >=, |
| RESTRICT = scalarltsel, |
| JOIN = scalarltjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_gt(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_gt, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(agtype, smallint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(smallint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(agtype, integer) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(integer, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(agtype, bigint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(bigint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(agtype, real) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(real, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(agtype, double precision) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(double precision, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(agtype, numeric) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_gt(numeric, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR > ( |
| FUNCTION = ag_catalog.agtype_any_gt, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = <, |
| NEGATOR = <=, |
| RESTRICT = scalargtsel, |
| JOIN = scalargtjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_le(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_le, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(agtype, smallint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(smallint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(agtype, integer) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(integer, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(agtype, bigint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(bigint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(agtype, real) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(real, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(agtype, double precision) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(double precision, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(agtype, numeric) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_le(numeric, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <= ( |
| FUNCTION = ag_catalog.agtype_any_le, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = >=, |
| NEGATOR = >, |
| RESTRICT = scalarlesel, |
| JOIN = scalarlejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_ge(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_ge, |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(agtype, smallint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = agtype, |
| RIGHTARG = smallint, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(smallint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = smallint, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(agtype, integer) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = agtype, |
| RIGHTARG = integer, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(integer, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = integer, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(agtype, bigint) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = agtype, |
| RIGHTARG = bigint, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(bigint, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = bigint, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(agtype, real) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = agtype, |
| RIGHTARG = real, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(real, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = real, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(agtype, double precision) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = agtype, |
| RIGHTARG = double precision, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(double precision, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = double precision, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(agtype, numeric) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = agtype, |
| RIGHTARG = numeric, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_any_ge(numeric, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR >= ( |
| FUNCTION = ag_catalog.agtype_any_ge, |
| LEFTARG = numeric, |
| RIGHTARG = agtype, |
| COMMUTATOR = <=, |
| NEGATOR = <, |
| RESTRICT = scalargesel, |
| JOIN = scalargejoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_btree_cmp(agtype, agtype) |
| RETURNS INTEGER |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR CLASS agtype_ops_btree |
| DEFAULT |
| FOR TYPE agtype |
| USING btree AS |
| OPERATOR 1 <, |
| OPERATOR 2 <=, |
| OPERATOR 3 =, |
| OPERATOR 4 >, |
| OPERATOR 5 >=, |
| FUNCTION 1 ag_catalog.agtype_btree_cmp(agtype, agtype); |
| |
| CREATE FUNCTION ag_catalog.agtype_hash_cmp(agtype) |
| RETURNS INTEGER |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR CLASS agtype_ops_hash |
| DEFAULT |
| FOR TYPE agtype |
| USING hash AS |
| OPERATOR 1 =, |
| FUNCTION 1 ag_catalog.agtype_hash_cmp(agtype); |
| |
| -- |
| -- agtype - access operators ( ->, ->> ) |
| -- |
| |
| CREATE FUNCTION ag_catalog.agtype_object_field(agtype, text) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- get agtype object field |
| CREATE OPERATOR -> ( |
| LEFTARG = agtype, |
| RIGHTARG = text, |
| FUNCTION = ag_catalog.agtype_object_field |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_object_field_text(agtype, text) |
| RETURNS text |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- get agtype object field as text |
| CREATE OPERATOR ->> ( |
| LEFTARG = agtype, |
| RIGHTARG = text, |
| FUNCTION = ag_catalog.agtype_object_field_text |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_array_element(agtype, int4) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- get agtype array element |
| CREATE OPERATOR -> ( |
| LEFTARG = agtype, |
| RIGHTARG = int4, |
| FUNCTION = ag_catalog.agtype_array_element |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_array_element_text(agtype, int4) |
| RETURNS text |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- get agtype array element as text |
| CREATE OPERATOR ->> ( |
| LEFTARG = agtype, |
| RIGHTARG = int4, |
| FUNCTION = ag_catalog.agtype_array_element_text |
| ); |
| |
| -- |
| -- Contains operators @> <@ |
| -- |
| CREATE FUNCTION ag_catalog.agtype_contains(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR @> ( |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| FUNCTION = ag_catalog.agtype_contains, |
| COMMUTATOR = '<@', |
| RESTRICT = contsel, |
| JOIN = contjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_contained_by(agtype, agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR <@ ( |
| LEFTARG = agtype, |
| RIGHTARG = agtype, |
| FUNCTION = ag_catalog.agtype_contained_by, |
| COMMUTATOR = '@>', |
| RESTRICT = contsel, |
| JOIN = contjoinsel |
| ); |
| |
| -- |
| -- Key Existence Operators ? ?| ?& |
| -- |
| CREATE FUNCTION ag_catalog.agtype_exists(agtype, text) |
| RETURNS boolean |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR ? ( |
| LEFTARG = agtype, |
| RIGHTARG = text, |
| FUNCTION = ag_catalog.agtype_exists, |
| COMMUTATOR = '?', |
| RESTRICT = contsel, |
| JOIN = contjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_exists_any(agtype, text[]) |
| RETURNS boolean |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR ?| ( |
| LEFTARG = agtype, |
| RIGHTARG = text[], |
| FUNCTION = ag_catalog.agtype_exists_any, |
| RESTRICT = contsel, |
| JOIN = contjoinsel |
| ); |
| |
| CREATE FUNCTION ag_catalog.agtype_exists_all(agtype, text[]) |
| RETURNS boolean |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE OPERATOR ?& ( |
| LEFTARG = agtype, |
| RIGHTARG = text[], |
| FUNCTION = ag_catalog.agtype_exists_all, |
| RESTRICT = contsel, |
| JOIN = contjoinsel |
| ); |
| |
| -- |
| -- agtype GIN support |
| -- |
| CREATE FUNCTION ag_catalog.gin_compare_agtype(text, text) |
| RETURNS int |
| AS 'MODULE_PATHNAME' |
| LANGUAGE C |
| IMMUTABLE |
| STRICT |
| PARALLEL SAFE; |
| |
| CREATE FUNCTION gin_extract_agtype(agtype, internal) |
| RETURNS internal |
| AS 'MODULE_PATHNAME' |
| LANGUAGE C |
| IMMUTABLE |
| STRICT |
| PARALLEL SAFE; |
| |
| CREATE FUNCTION ag_catalog.gin_extract_agtype_query(agtype, internal, int2, |
| internal, internal) |
| RETURNS internal |
| AS 'MODULE_PATHNAME' |
| LANGUAGE C |
| IMMUTABLE |
| STRICT |
| PARALLEL SAFE; |
| |
| CREATE FUNCTION ag_catalog.gin_consistent_agtype(internal, int2, agtype, int4, |
| internal, internal) |
| RETURNS bool |
| AS 'MODULE_PATHNAME' |
| LANGUAGE C |
| IMMUTABLE |
| STRICT |
| PARALLEL SAFE; |
| |
| CREATE FUNCTION ag_catalog.gin_triconsistent_agtype(internal, int2, agtype, int4, |
| internal, internal, internal) |
| RETURNS bool |
| AS 'MODULE_PATHNAME' |
| LANGUAGE C |
| IMMUTABLE |
| STRICT |
| PARALLEL SAFE; |
| |
| CREATE OPERATOR CLASS ag_catalog.gin_agtype_ops |
| DEFAULT FOR TYPE agtype USING gin AS |
| OPERATOR 7 @>, |
| OPERATOR 9 ?(agtype, text), |
| OPERATOR 10 ?|(agtype, text[]), |
| OPERATOR 11 ?&(agtype, text[]), |
| FUNCTION 1 ag_catalog.gin_compare_agtype(text,text), |
| FUNCTION 2 ag_catalog.gin_extract_agtype(agtype, internal), |
| FUNCTION 3 ag_catalog.gin_extract_agtype_query(agtype, internal, int2, |
| internal, internal), |
| FUNCTION 4 ag_catalog.gin_consistent_agtype(internal, int2, agtype, int4, |
| internal, internal), |
| FUNCTION 6 ag_catalog.gin_triconsistent_agtype(internal, int2, agtype, int4, |
| internal, internal, internal), |
| STORAGE text; |
| |
| -- |
| -- graph id conversion function |
| -- |
| CREATE FUNCTION ag_catalog.graphid_to_agtype(graphid) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (graphid AS agtype) |
| WITH FUNCTION ag_catalog.graphid_to_agtype(graphid); |
| |
| CREATE FUNCTION ag_catalog.agtype_to_graphid(agtype) |
| RETURNS graphid |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (agtype AS graphid) |
| WITH FUNCTION ag_catalog.agtype_to_graphid(agtype) |
| AS IMPLICIT; |
| |
| |
| -- |
| -- agtype - path |
| -- |
| CREATE FUNCTION ag_catalog._agtype_build_path(VARIADIC "any") |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- agtype - vertex |
| -- |
| CREATE FUNCTION ag_catalog._agtype_build_vertex(graphid, cstring, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- agtype - edge |
| -- |
| CREATE FUNCTION ag_catalog._agtype_build_edge(graphid, graphid, graphid, cstring, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog._ag_enforce_edge_uniqueness(VARIADIC "any") |
| RETURNS bool |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| as 'MODULE_PATHNAME'; |
| |
| -- |
| -- agtype - map literal (`{key: expr, ...}`) |
| -- |
| |
| CREATE FUNCTION ag_catalog.agtype_build_map(VARIADIC "any") |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_build_map() |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME', 'agtype_build_map_noargs'; |
| |
| -- |
| -- There are times when the optimizer might eliminate |
| -- functions we need. Wrap the function with this to |
| -- prevent that from happening |
| -- |
| CREATE FUNCTION ag_catalog.agtype_volatile_wrapper(agt agtype) |
| RETURNS agtype AS $return_value$ |
| BEGIN |
| RETURN agt; |
| END; |
| $return_value$ LANGUAGE plpgsql |
| VOLATILE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE; |
| |
| -- |
| -- agtype - list literal (`[expr, ...]`) |
| -- |
| |
| CREATE FUNCTION ag_catalog.agtype_build_list(VARIADIC "any") |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_build_list() |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| CALLED ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME', 'agtype_build_list_noargs'; |
| |
| -- |
| -- agtype - type coercions |
| -- |
| -- agtype -> text (explicit) |
| CREATE FUNCTION ag_catalog.agtype_to_text(agtype) |
| RETURNS text |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (agtype AS text) |
| WITH FUNCTION ag_catalog.agtype_to_text(agtype); |
| |
| -- agtype -> boolean (implicit) |
| CREATE FUNCTION ag_catalog.agtype_to_bool(agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (agtype AS boolean) |
| WITH FUNCTION ag_catalog.agtype_to_bool(agtype) |
| AS IMPLICIT; |
| |
| -- boolean -> agtype (explicit) |
| CREATE FUNCTION ag_catalog.bool_to_agtype(boolean) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (boolean AS agtype) |
| WITH FUNCTION ag_catalog.bool_to_agtype(boolean); |
| |
| -- float8 -> agtype (explicit) |
| CREATE FUNCTION ag_catalog.float8_to_agtype(float8) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (float8 AS agtype) |
| WITH FUNCTION ag_catalog.float8_to_agtype(float8); |
| |
| -- agtype -> float8 (implicit) |
| CREATE FUNCTION ag_catalog.agtype_to_float8(agtype) |
| RETURNS float8 |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (agtype AS float8) |
| WITH FUNCTION ag_catalog.agtype_to_float8(agtype); |
| |
| -- int8 -> agtype (explicit) |
| CREATE FUNCTION ag_catalog.int8_to_agtype(int8) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (int8 AS agtype) |
| WITH FUNCTION ag_catalog.int8_to_agtype(int8); |
| |
| -- agtype -> int8 |
| CREATE FUNCTION ag_catalog.agtype_to_int8(variadic "any") |
| RETURNS bigint |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (agtype AS bigint) |
| WITH FUNCTION ag_catalog.agtype_to_int8(variadic "any") |
| AS ASSIGNMENT; |
| |
| -- agtype -> int4 |
| CREATE FUNCTION ag_catalog.agtype_to_int4(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(variadic "any"); |
| |
| -- agtype -> int2 |
| CREATE FUNCTION ag_catalog.agtype_to_int2(variadic "any") |
| RETURNS smallint |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE CAST (agtype AS smallint) |
| WITH FUNCTION ag_catalog.agtype_to_int2(variadic "any"); |
| |
| -- 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"); |
| -- |
| -- agtype - access operators |
| -- |
| |
| -- for series of `map.key` and `container[expr]` |
| CREATE FUNCTION ag_catalog.agtype_access_operator(VARIADIC agtype[]) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_access_slice(agtype, agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_in_operator(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- agtype - string matching (`STARTS WITH`, `ENDS WITH`, `CONTAINS`, & =~) |
| -- |
| |
| CREATE FUNCTION ag_catalog.agtype_string_match_starts_with(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_string_match_ends_with(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.agtype_string_match_contains(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_eq_tilde(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- functions for updating clauses |
| -- |
| |
| -- This function is defined as a VOLATILE function to prevent the optimizer |
| -- from pulling up Query's for CREATE clauses. |
| CREATE FUNCTION ag_catalog._cypher_create_clause(internal) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog._cypher_set_clause(internal) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog._cypher_delete_clause(internal) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog._cypher_merge_clause(internal) |
| RETURNS void |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- query functions |
| -- |
| CREATE FUNCTION ag_catalog.cypher(graph_name name = NULL, |
| query_string cstring = NULL, |
| params agtype = NULL) |
| RETURNS SETOF record |
| LANGUAGE c |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.get_cypher_keywords(OUT word text, OUT catcode "char", |
| OUT catdesc text) |
| RETURNS SETOF record |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| COST 10 |
| ROWS 60 |
| AS 'MODULE_PATHNAME'; |
| |
| -- |
| -- Scalar Functions |
| -- |
| CREATE FUNCTION ag_catalog.age_id(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_start_id(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_end_id(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_head(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_last(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_properties(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_startnode(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_endnode(agtype, agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_length(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_toboolean(variadic "any") |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_tofloat(variadic "any") |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_tointeger(variadic "any") |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_tostring(variadic "any") |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_size(variadic "any") |
| RETURNS agtype |
| LANGUAGE c |
| IMMUTABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_type(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_exists(agtype) |
| RETURNS boolean |
| LANGUAGE c |
| STABLE |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'; |
| |
| CREATE FUNCTION ag_catalog.age_label(agtype) |
| RETURNS agtype |
| LANGUAGE c |
| STABLE |
| RETURNS NULL ON NULL INPUT |
| PARALLEL SAFE |
| AS 'MODULE_PATHNAME'
|