Module

x/kysely_postgrs_js_dialect/deps.ts>kysely.OnConflictUpdateBuilder#clearWhere

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

Clears all where expressions from the query.

Examples

db.selectFrom('person')
  .selectAll()
  .where('id','=',42)
  .clearWhere()

The generated SQL(PostgreSQL):

select * from "person"