Zainab-Saad opened a new issue, #824:
URL: https://github.com/apache/age/issues/824
**Is your feature request related to a problem? Please describe.**
The typecasting from bool data type to integer and vice versa is not
supported
The query:
`agedb=# SELECT * FROM cypher('graph', $$
RETURN 1::bool
$$) AS (result agtype);`
outputs:
`ERROR: typecast 'bool' not supported
LINE 1: SELECT * FROM cypher('graph', $$`
and
`agedb=# SELECT * FROM cypher('graph', $$
RETURN true::integer
$$) AS (result agtype);`
output:
`ERROR: typecast expression must be a number or a string`
**Describe the solution you'd like**
To the point I have debugged, issue lies with transform_cypher_typecast
function in backend/parser/cypher_expr.c and thus some modifications need to be
made there
**Describe alternatives you've considered**
N/A
**Additional context**
This feature of typecasting bool to integer and vice versa is supported in
postgres, thus it would be worth adding this feature to AGE as well.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
