Skip to content

Incorrect indentation in PostgreSQL DELETE FROM ... USING #683

Open
@karlhorky

Description

@karlhorky

Describe the Feature

More consistent formatting for multiple joined tables after the USING keyword in a DELETE FROM ... USING query (consistent compared to SELECT ... FROM ... JOIN:

Input data

Which SQL and options did you provide as input?

DELETE FROM films
USING
  producers,
  sessions
WHERE sessions.id = '123' AND producer_id = producers.id AND producers.name = 'foo';

Expected Output

DELETE FROM
  films
  USING
    producers,
    sessions
WHERE
  sessions.id = '123'
  AND producer_id = producers.id
  AND producers.name = 'foo';

Actual Output

DELETE FROM films USING producers,
sessions
WHERE
  sessions.id = '123'
  AND producer_id = producers.id
  AND producers.name = 'foo';

Why do you want this feature?

To be more consistent with the SELECT ... FROM ... JOIN formatting:

SELECT
  *
FROM
  candidates
  INNER JOIN sessions ON users.session_id = sessions.id

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions