songololo opened a new issue #84:
URL: https://github.com/apache/incubator-age/issues/84
I'm trying to do a relatively basic MATCH with a WHERE clause but I keep
encountering an error per:
```
ERROR: operator is not unique: ag_catalog.agtype = ag_catalog.agtype
Hint: Could not choose a best candidate operator. You might need to add
explicit type casts. Position: 93
```
The item and its item property exists in the graph.
This is the query:
```postgresql
SELECT *
FROM ag_catalog.cypher('my_test_graph', $$
MATCH (n:some_label)
WHERE n.pkey = 'some123string456'
RETURN n.pkey
$$) as (v ag_catalog.agtype);
```
Where `some_label` and `some123string456` correspond to the vertex labels
and properties in the graph.
The `pkey` property is stored as a string.
I've tried adding explicit type casts, e.g. ::text and ::char but these
return the following errors:
```
ERROR: typecast 'text' not supported
```
When I reframe the query per:
```
SELECT *
FROM ag_catalog.cypher('my_test_graph', $$
MATCH (n:some_label {pkey: 'some123string456'})
RETURN n.pkey
$$) as (v ag_catalog.agtype);
```
then it works.
--
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.
For queries about this service, please contact Infrastructure at:
[email protected]
