1

I used agensgraph version 1.3. Following query 

'MATCH (a:movie) RETURN a.title

gives result:

              title
---------------------------------
 "The Matrix"
 "The Matrix Reloaded"
 "The Matrix Revolutions"
 "The Devils Advocate"
 "A Few Good Men"
 "Top Gun"
 "Jerry Maguire"
 "Stand By Me"

I don't know why is double quote operator. What is the way to replace ""?

barbsan
  • 3,418
  • 11
  • 21
  • 28
전현수
  • 11
  • 1

1 Answers1

0

You can use function "btrim" for removing needless quotes.

agens=# select btrim( n.value::text, '"' ) from ( match (n) return n.value ) as n;
 btrim 
-------
 test
(1 row)

You must use trim on SQL part of quires for removing quotes.

jagger
  • 13
  • 2