How should I call the builtin Apache AGE function _agtype_build_vertex from psql terminal?

Question

From the psql terminal, I'm trying to use an Apache AGE builtin function with the following signature:

Datum _agtype_build_vertex(PG_FUNCTION_ARGS)

the function is located here: https://github.com/apache/age/blob/a84c0392ffcfe63ecbc70ca4b45f1f0c3de28f7d/src/backend/utils/adt/agtype.c#L2167

but I wasn't able to call it with the proper arguments.

I tried the following commands on psql terminal (the error messages are shown below the commands):

test=# select _agtype_build_vertex(1,"vertex", "{}");
-- "ERROR:  column "vertex" does not exist at character 22"

test=# SELECT agtype_build_vertex(1,"_ag_label_vertex","{}");
ERROR:  column "_ag_label_vertex" does not exist at character 30

test=# SELECT * FROM agtype_build_vertex(1,"_ag_label_vertex","{}");
ERROR:  column "_ag_label_vertex" does not exist at character 37

What would be the proper way to call this function?

abhishek2046 · Accepted Answer · 2023-03-28 05:56:38Z

3

These are some of the correct ways of calling the function from psql terminal and also age-viewer.

--Basic Vertex Creation
SELECT _agtype_build_vertex('1'::graphid, $$label_name$$, agtype_build_map());
SELECT _agtype_build_vertex('1'::graphid, $$label$$, agtype_build_map('id', 2));

--Null properties
SELECT _agtype_build_vertex('1'::graphid, $$label_name$$, NULL);

This SQL script has many more examples of calling _agtype_build_vertex and other functions.

edited Mar 28, 2023 at 5:56

answered Mar 28, 2023 at 5:31

abhishek2046

7023 gold badges8 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hannan aamir · Accepted Answer · 2023-09-15 12:21:24Z

0

After looking in the sql files the function is called in your problem might me that you are not passing the label name in cypher form. try this query instead of the one your are executing.

SELECT agtype_build_vertex(1,$$vertex$$,NULL);

I hope this helps.

answered Sep 15, 2023 at 12:21

hannan aamir

94 bronze badges

Comments

Pratik Kumar · Accepted Answer · 2023-03-27 22:10:04Z

-1

agtype_build_vertex function to build a vertex using the agtype data type. The function takes two parameters: the vertex label and a JSON object representing the properties of the vertex.

SELECT _agtype_build_vertex('Timetable', '{"subject": "English", "duration": 3}');

This will create a vertex with the label "person" and the properties "name" and "age" in the current database.

answered Mar 27, 2023 at 22:10

Pratik Kumar

343 bronze badges

Collectives™ on Stack Overflow

How should I call the builtin Apache AGE function _agtype_build_vertex from psql terminal?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related