HtLim

Results 4 comments of HtLim

Hi @VinACE You can use [to_jsonb() function](https://www.postgresql.org/docs/current/static/functions-json.html#FUNCTIONS-JSON-CREATION-TABLE). e.g.) MATCH (po: p_order) WHERE (po.b_amount) < to_jsonb((SELECT amt FROM master WHERE v = '3')) RETURN properties(po) AS p_order LIMIT 10;

@VinACE You can use int4(), int8() function, too. e.g.) MATCH (po: p_order) WHERE int4(po.b_amount) < (SELECT amt FROM master WHERE v = '3') RETURN properties(po) AS p_order LIMIT 10;

Hi @VinACE If 'comp_2_p' is an edge label, you can fix it by putting a semicolon on the edge.

Hi. @VinACE You might want to refer to [this site](https://www.postgresql.org/docs/devel/static/sql-select.html#SQL-DISTINCT).