You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/05/05 08:01:23 UTC
[GitHub] [incubator-age] wqxs opened a new issue, #213: How do I get valid values in a property?
wqxs opened a new issue, #213:
URL: https://github.com/apache/incubator-age/issues/213
This is in properties
`{"userName":"ry"}`
when i go to get it
`SELECT *
FROM ag_catalog.cypher('zjdata_graph', $$
MATCH (u:sys_user {userId: 1})
RETURN u.userName
$$) as (userName ag_catalog.agtype);`
The result is
![image](https://user-images.githubusercontent.com/69672009/166883291-2941bdc6-e9d8-4194-a6a7-37b31f341892.png)
and the result I want is ry instead of "ry"
--
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-unsubscribe@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-age] wqxs closed issue #213: How do I get valid values in a property?
Posted by GitBox <gi...@apache.org>.
wqxs closed issue #213: How do I get valid values in a property?
URL: https://github.com/apache/incubator-age/issues/213
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-age] JoshInnis commented on issue #213: How do I get valid values in a property?
Posted by GitBox <gi...@apache.org>.
JoshInnis commented on issue #213:
URL: https://github.com/apache/incubator-age/issues/213#issuecomment-1120030015
You can typecast agtype to text `SELECT * FROM ag_catalog.cypher('zjdata_graph', $$ MATCH (u:sys_user {userId: 1}) RETURN u.userName $$) as (userName text); `
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-age] pdpotter commented on issue #213: How do I get valid values in a property?
Posted by GitBox <gi...@apache.org>.
pdpotter commented on issue #213:
URL: https://github.com/apache/incubator-age/issues/213#issuecomment-1118283447
You'll have to parse the result. Agtype is a superset of Json and a custom implementation of JsonB. For detailed information, see https://age.apache.org/docs/master/intro/types.html (https://age.apache.org/docs/master/intro/types.html#string specificly for strings).
If you query the database from an application written in Go, Java, Javascript (NodeJs) or Python, you can use the corresponding driver from https://github.com/apache/incubator-age/tree/master/drivers to parse the result.
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-age] JoshInnis commented on issue #213: How do I get valid values in a property?
Posted by GitBox <gi...@apache.org>.
JoshInnis commented on issue #213:
URL: https://github.com/apache/incubator-age/issues/213#issuecomment-1120029908
You can typecast agtype to text `SELECT * FROM ag_catalog.cypher('zjdata_graph', $$ MATCH (u:sys_user {userId: 1}) RETURN u.userName $$) as (userName text); `
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org