Module

x/kysely_postgrs_js_dialect/deps.ts>kysely.NotMatchedThenableMergeQueryBuilder#thenDoNothing

Kysely dialect for PostgreSQL using the Postgres.js client.
Byzanteam/kysely_postgres_js_dialect
Go to Latest
method kysely.NotMatchedThenableMergeQueryBuilder.prototype.thenDoNothing
import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/deps.ts";
const { NotMatchedThenableMergeQueryBuilder } = kysely;

Performs the do nothing action.

This is supported in PostgreSQL.

To perform the insert action, see {@link thenInsertValues}.

Examples

const result = await db.mergeInto('person')
  .using('pet', 'person.id', 'pet.owner_id')
  .whenNotMatched()
  .thenDoNothing()
  .execute()

The generated SQL (PostgreSQL):

merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when not matched then
  do nothing