Zainab-Saad commented on issue #1521: URL: https://github.com/apache/age/issues/1521#issuecomment-1911907648
The error you are getting is because the operator `->` is overloaded (in version 1.5.0) with the following possible operands `agtype -> agtype` `agtype -> text` `agtype -> int` In the query `select properties->'ott' from ott_service_1.ott_company;`, `'ott'` is of the type `unknown` and when such a type is provided as second argument to the operator ->, postgres chooses the operator `agtype -> agtype` instead of `agtype -> text`. And `'ott'` is not in valid agtype format (should be `'"ott"'`), so you get an error. You can read why specific operator is choosen when `unknown` type is provided in the operator type resolution section [here](https://www.postgresql.org/docs/16/typeconv-oper.html) -- 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-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
