Use postgreSQL native functions inside cypher query (AGE)

mohayu22

mohayu22

Posted on June 15, 2023

Use postgreSQL native functions inside cypher query (AGE)

Although there are numerous helpful functions available in PostgreSQL that you might want to utilize in your project, they cannot be directly used in a Cypher query.

To incorporate PostgreSQL's functions within a Cypher query, one approach is to create wrapper functions in AGE. These wrapper functions should be prefixed with age_ when writing C code. However, when using these functions in a Cypher query, there's no need to include the prefix.

To invoke the desired PostgreSQL function within the wrapper function, you can employ the DirectFunctionCallX macro. Remember to include the file where the function is located to ensure proper compilation and execution.

💖 💪 🙅 🚩
mohayu22
mohayu22

Posted on June 15, 2023

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related