Is there alternative of "similar to" on AgensGraph?

Question

I want to find string using regular expression on AgensGraph.

agens=# create (:v1{value:'text'});
GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0)
agens=# match (n:v1) where n.value similar to 't%' return n;
ERROR:  syntax error at or near "similar"
LINE 1: match (n:v1) where n.value similar to 't%' return n;
                                   ^

But, there is an error on it.

score 0 · Answer 1 · answered Jun 28 '19 at 03:52

0

Use operator "=~" for search using regex patten.

agens=# match (n:v1) where n.value =~ 't*' return n;
            n             
--------------------------
 v1[3.1]{"value": "text"}
(1 row)

answered Jun 28 '19 at 03:52

mekhi

13
3

Is there alternative of "similar to" on AgensGraph?

1 Answers1