Module

x/kysely_postgrs_js_dialect/deps.ts>kysely.CreateIndexBuilder#nullsNotDistinct

Kysely dialect for PostgreSQL using the Postgres.js client.
method kysely.CreateIndexBuilder.prototype.nullsNotDistinct
import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/deps.ts";
const { CreateIndexBuilder } = kysely;

Adds nulls not distinct specifier to index. This only works on some dialects like PostgreSQL.

Examples

db.schema.createIndex('person_first_name_index')
 .on('person')
 .column('first_name')
 .nullsNotDistinct()
 .execute()

The generated SQL (PostgreSQL):

create index "person_first_name_index"
on "test" ("first_name")
nulls not distinct;