Re: [I] How to handle the param if there're single quotes in it? [age]

[via GitHub]

noahxzhu commented on issue #1722:
URL: https://github.com/apache/age/issues/1722#issuecomment-2040174819

   > > > Can you put double quotes around the string?
   > > > ```cypher
   > > > SELECT * from ag_catalog.cypher('graph_store', $$
   > > >      MERGE (n1:`Entity` {id: 'I'})
   > > >      MERGE (n2:`Entity` {id: "It's better for technology companies to 
be run by product people"})
   > > >      MERGE (n1)-[:`Learned`]->(n2)
   > > > $$) as (a ag_catalog.agtype);
   > > > ```
   > > > 
   > > > 
   > > >     
   > > >       
   > > >     
   > > > 
   > > >       
   > > >     
   > > > 
   > > >     
   > > >   
   > > > This worked for me alright
   > > 
   > > 
   > > @markgomer I just copy and paste yours, it seems not work
   > > ![CleanShot 2024-04-05 at 23 46 
19@2x](https://private-user-images.githubusercontent.com/8643866/320061243-cb16b2aa-09b2-4a94-94bc-6e752b04c3b2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTIzMzI1MDgsIm5iZiI6MTcxMjMzMjIwOCwicGF0aCI6Ii84NjQzODY2LzMyMDA2MTI0My1jYjE2YjJhYS0wOWIyLTRhOTQtOTRiYy02ZTc1MmIwNGMzYjIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDQwNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA0MDVUMTU1MDA4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MDE1Yzc4OGJmMTA3MDEwMWExYWM5MGUxYjU3MmRmMTdhYjg1N2IyNzBjM2ZlNDQ1Y2M0YzMxYjVjZjlmMDI0MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.I_akTn9vwmn3CJ8uR-0tgiglnF06j2w1u2rO0p_QMHU)
   > 
   > Try setting the search_path:
   > 
   > ```cypher
   > SET search_path TO ag_catalog;
   > ```
   > 
   > I'm not sure why it is not working without this, though.
   
   After setting the search_path, now it's working, but why?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org