Repository navigation
The ->> operation in postgresql does not work properly #1571
Description
Activity
The problem here is that JSqlParser does only support:
column ->> literal
a function as a first "parameter" is not supported. Something you want to provide. PRs are welcome.
I'm using the latest version 4.6 and this problem seems not solved yet.
Would it be possible to be fixed in the future?Unfortunately, allowing
Function()is not possible as it will break performance reason. I think, this one is beyond any refactoring and tricks. A new and clean Grammar would be needed to achieve that.Unfortunately, allowing
Function()is not possible as it will break performance reason. I think, this one is beyond any refactoring and tricks. A new and clean Grammar would be needed to achieve that.Thank you for your reply.
I'll check my code to see if it can be refactored.- added a commit that references this issue
on Mar 14, 2023 PR #1745 allows
Function() ->> Literalas long as the Function is simple (no nested expressions as parameters).- added a commit that references this issue
on Apr 27, 2023
select visit_hour,json_array_elements(into_sex_json)->>'name',json_array_elements(into_sex_json)->>'value' from period_market