[FORMATTING] Spaceship operator (<=>) adding unwanted whitespace

[nerixim]

Input data

Which SQL and options did you provide as input?
LangChain function for vector search.

BEGIN RETURN query
SELECT
  documents.id,
  documents.content,
  documents.metadata AS documents_metadata,
  1 - (documents.embedding <=> query_embedding) AS similarity
FROM
  documents
ORDER BY
  documents.embedding <=> query_embedding
LIMIT
  match_count;

END;

Expected Output

BEGIN RETURN query
SELECT
  documents.id,
  documents.content,
  documents.metadata AS documents_metadata,
  1 - (documents.embedding <=> query_embedding) AS similarity
FROM
  documents
ORDER BY
  documents.embedding <=> query_embedding
LIMIT
  match_count;

END;

Actual Output

BEGIN RETURN query
SELECT
  documents.id,
  documents.content,
  documents.metadata AS documents_metadata,
  1 - (documents.embedding <= > query_embedding) AS similarity
FROM
  documents
ORDER BY
  documents.embedding <= > query_embedding
LIMIT
  match_count;

END;

Usage

• How are you calling / using the library?
  VSCode (yes, I've set the dialect).

• What SQL language(s) does this apply to?
  Postgres

• Which SQL Formatter version are you using?
  Extension version 1.6.0

[nene]

First off, please read the FAQ with regards to this specific VSCode extension.

Second, yep, this operator also looks unsupported in the latest version of the library. Thanks for reporting.

[nene]

So, as I understand, this is not a builtin operator in PostgreSQL, but rather a custom one provided by the pgvector extension, among several other operators.

So, this really comes down to the formatter not supporting all possible custom operators in PostgreSQL.

[nene]

Implemented a support for these specific operators. Though the larger problem with custom operators support remains.

[nene]

Fixed in 15.4.7