Question 89471 in PostgreSQL Question posted in
The official documentation can be found here.

Why am i getting an error using the CALL() function on a cypher query? – Postgresql

Im running the regression tests in the apacheAGE extension line by line just to see how they work and play around, but in this one : https://github.com/apache/age/blob/master/regress/sql/cypher_call.sql
i get an error : CALL NOT SUPPORTED YET

I carefully run each line so its not a copy-paste error thing. Maybe i have an outdated version of the extension?
Im using postgres VERSION = PostgreSQL 12.14
and apacheAGE release PG12 1.1.1

Tags:

2

Answers


  1. 0

    You basically answered your own question. The Error CALL not supported yet says that your correct version does not have the function which means you are probably using a previous version of Apache Age.

    According to the documentation, the CALL statement was added in version 0.3.0. So, you need to upgrade your APACHE AGE version.

    1. Check your Apache Age version by running the following command in the Apache AGE shell:
    VERSION
    1. Upgrade your APACHE AGE version by directly cloning the Apache age gitHub repository or following the download instructions from the Apache Age website.
    Login or Signup to reply.
  2. 0

    CALL is defined in v1.1.0 of the extension (according to release notes), however, you could simply use

    SELECT * FROM cypher('graph_name', $$ RETURN sqrt(64) $$) as (v agtype)

    to call the sqrt function

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search