Skip to main content
Using Deno in production at your company? Earn free Deno merch.
Give us feedback
Module

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

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

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

Unlike whenMatchedAndRef, you cannot reference columns from the target table.

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

Type Parameters

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