[GitHub] [incubator-age] Misterion777 commented on issue #106: Agtype casting

[GitBox <gi...@apache.org>]

Misterion777 commented on issue #106:
URL: https://github.com/apache/incubator-age/issues/106#issuecomment-901857510


   > Hello there.
   > 
   > wonder if i exactly give what you just want to.
   > 
   > If you try just like this,
   > 
   > ```
   > WITH result as (
   > SELECT *
   > FROM cypher('test', $$
   > WITH [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] as lst
   > RETURN lst
   > $$) AS ( lst agtype ) 
   > )select 
   > string_to_array(ltrim(rtrim(array_to_string(array_agg(lst), ','), ']'),'['),',')::int[] from result;
   > ```
   > 
   > You'll got this result
   > 
   > ```
   >      string_to_array
   > --------------------------
   >  {0,1,2,3,4,5,6,7,8,9,10}
   > (1 row)
   > ```
   > 
   > AGE support type casting restrictively. You can find in http://age.incubator.apache.org/docs/Apache_AGE_Guide.pdf which type can be casted.
   > 
   > Is this what you wanted? If not, just leave a comment plz.
   
   Hello, yes the result is what I wanted, but the implementation seems like a duct tape, I think it should be possible to do that in a more obvious and intuitive way.


-- 
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