How can I get values as specific type when using 'with'? about age HOT 4 CLOSED

I don't know English well, so I don't know if I understood your question well. If I understood your question well,
I think this question can explain your curiosity.

CREATE EXTENSION age;
LOAD 'age';
SET search_path = ag_catalog, "postgres", public;

SELECT create_graph('test_graph');

SELECT * from cypher('test_graph', $$
CREATE (a:Part {part_num: '123'}),
(b:Part {part_num: '345'}),
(c:Part {part_num: '456'}),
(d:Part {part_num: '789'})
$$) as (a agtype);

select * from cypher('test_graph', $$ match(v:Part) where id(v) = 844424930131969 return v.part_num $$) as (result text);

with a as(select * from cypher('test_graph', $$ match(v:Part) where id(v) = 844424930131969 return v.part_num $$) as (result text))
select a from a;

1. If the cypher query result is in text format, you can cast it in text format.
2. To query using a specific id value, you can use the id function where id function.

from age.

Of course, it returns text type when I use cypher query only(as (result text)).
I want know when I use 'with', how I get data that I wanted type.

Here is returned value in queried that.

from age.

Is this what you want?

select "result", "id" from cypher('test_graph', $$ match(v:Part) where id(v) = 844424930131969 return v.part_num , id(v) $$) as (result text, id text);

with a as(
select * from cypher('test_graph', $$ match(v:Part) where id(v) = 844424930131969 return v.part_num , id(v) $$) as (result text, id text)
)
select "result", "id" from a;

from age.

Oh yes. it's correct.

Thanks to reply.

from age.