age: Query resulting in error: cannot cast agtype integer to type boolean

Hello again (this might happen a lot).

I’m getting the following error when trying to run the below query: cannot cast agtype integer to type boolean (in NodeJS, using pg library):

    SELECT * FROM ag_catalog.cypher('minmail', $$      
    MATCH (u:User {_id: $userId})-[:has]->(p:Profile)
    WHERE p.deleted IS NULL
    RETURN p
    $$, $1) as (p ag_catalog.agtype);

Params:

 '{"userId":"e4510317-67dc-4002-b28d-347699c8f8ca"}' 

Any clue as to what I might be doing wrong?

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Comments: 15 (8 by maintainers)

Most upvoted comments

Additionally, in current docker image automatically execute CREATE EXTENSION(default database) and LOAD statement.

There is no upgrade script to upgrade to latest. In order to use the latest version, I think you will have to drop the extension age DROP EXTENSION age CASCADE and then create it again CREATE EXTENSION age if possible (this will delete all data in your graph database).