 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Olegon
Joined: 07 Sep 2009 Posts: 40
|
|
Formatting @> Postgres operator |
|
Hello!
The
 |
 |
@> |
operator in Postgres after formating become
 |
 |
@ > |
Example of usage:
 |
 |
select '[2025-01-01,2025-02-15)'::date range @> '2025-02-01'::date as is_date_in_range |
Can I fix this by adding formatting rule? How?
Tried add simple rule
 |
 |
@> |
but it didn't help.
SQL Assistant 13.0.56
|
|
Wed Feb 26, 2025 4:35 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7942
|
|
|
|
It looks like it finds > and adds spaces around that one not considering that @> is a single operator in Postgres.
You can try disabling Space Before and After Operator option. But it will effect all operators, not just this one.
I'm afraid that fixing specifically how @> is treated requires internal code changes on our part.
|
|
Wed Feb 26, 2025 10:01 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2160
|
|
|
|
This is similar to some earlier issues regarding operators in MariaDB and Postgres, see >>>here<<<. It is likely that all the multi-character operators are (or were) affected.
|
|
Thu Feb 27, 2025 8:55 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7942
|
|
|
|
It's the same kind of issue.
|
|
Thu Feb 27, 2025 9:44 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|