SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Formatting @> Postgres operator

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Formatting @> Postgres operator
Author Message
Olegon



Joined: 07 Sep 2009
Posts: 40

Post Formatting @> Postgres operator Reply with quote
Hello!

The
Code:
@>
operator in Postgres after formating become
Code:
@ >


Example of usage:
Code:
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
Code:
@>
but it didn't help.

SQL Assistant 13.0.56
Wed Feb 26, 2025 4:35 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7942

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2160

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7942

Post Reply with quote
It's the same kind of issue.
Thu Feb 27, 2025 9:44 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.