cho2hhun opened a new issue, #1234:
URL: https://github.com/apache/age/issues/1234
I've used Agens Graph and AGE many times, and I think there is a point that
hope to revise like Agens Graph
In AGE, it cannot use **PostgreSQL function in Cypher query** but Agens
Graph was possible to use PG function in Cypher clause
the example is like below
**[case 1. AGE ]**
```
select * from cypher ('car' $$
match (a : vt_car) -[r : eg_eng_use2]->(b : vt_engine)
return corr(r.fe, r.co2) as corr $$) as (corr numeric)
```
then error is occured like below
```
ERROR: function ag_catalog.age_corr(agtype, agtype) does not exist
```
**[case 2. Agens Graph]**
```
match (a : vt_car) -[r : eg_eng_use2]->(b : vt_engine)
return corr(r.fe, r.co2) as corr
```
In the case of Agens Graph, It is possible to use PG function in Cypher
clause
the thing that you need to notice is that ```corr()``` is a **PostgreSQL
function**
I think the schema ```ag_catalog``` doesnt have **PG functions** but only
have AGE's unique functions
So I Think it might as well to add PG function in ```ag_catalog``` So we can
use PG functions in Cypher clause and It could be fluent **Hybrid Query**!!!
cause many people dont know exactly about Cypher functions, It might be really
good for user who is knowing for PG SQL
**Environment (please complete the following information):**
- Version: 13
--
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.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
