Module

x/kysely_postgrs_js_dialect/mod.ts>kysely.WheneableMergeQueryBuilder#whenNotMatchedAndRef

Kysely dialect for PostgreSQL using the Postgres.js client.
Latest
method kysely.WheneableMergeQueryBuilder.prototype.whenNotMatchedAndRef
import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/mod.ts";
const { WheneableMergeQueryBuilder } = kysely;

Adds the when not matched clause to the query with an and condition. But unlike {@link whenNotMatchedAnd}, this method accepts a column reference as the 3rd argument.

Unlike {@link whenMatchedAndRef}, you cannot reference columns from the target table.

This method is similar to {@link SelectQueryBuilder.whereRef}, so see the documentation for that method for more examples.

Type Parameters

LRE extends ReferenceExpression<DB, ST>
RRE extends ReferenceExpression<DB, ST>