Skip to content

Add MERGE INTO support #2272

Description

@jo2y

What do you want to change?

Free unicorns, plus MERGE INTO!

Postgresql 15 has a MERGE command that sqlc does not appear to support. In fact, it seems to fail silently with no output.

It is somewhat similar in function to an upsert, but allows more guidance to the engine on what to do if the row exists or doesn't exist.

It's a little unclear to me if MySQL and MariaDB support the command. I see third-party blogs and tutorials suggesting its use, but I'm failing to find it in the official docs.

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

Go

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