Several PostgreSQL operators are incorrectly split in two

[Diggsey]

Some examples I've encountered:

Before	After
<->	< ->
<=>	<= >
&&	& &
@>	@ >

There are probably many more. I think the formatter should avoid splitting adjacent symbols like this entirely.

[pnezis]

Some other examples that are wrongly split:

SELECT
  left <@ right,
  left << right,
  left >> right,
  left &< right,
  left &> right,
  left -|- right,
  @@ left,
  @-@ left,
  left <-> right,
  left <<| right,
  left |>> right,
  left &<| right,
  left |>& right,
  left <^ right,
  left >^ right,
  ?- left,
  left ?-| right,
  left ?|| right,
  left ~= right

Notice that this is only a tiny subset of postgres supported operators. You can get the full list by running

select * from pg_operator;

Additionally you are allowed to create your own operator through CREATE OPERATOR. The allowed operator characters are + - * / < > = ~ ! @ # % ^ & | ?`.

I agree with @Diggsey that the tokenizer should avoid splitting sequences of the above symbols in order to be safe. Currently it breaks queries using such operators.

[akoutmos]

With #57 merged in I think this issue is solved. Any chance we could get a release so I can update my library that depends on sqlformat-rs? Really appreciate the effort you put into this library!

[shssoichiro]

Pushed a new release, please let me know if this is still an issue. Thanks.