Module

x/kysely_postgrs_js_dialect/deps.ts>kysely.QueryCreator#withRecursive

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

Creates a recursive with query (Common Table Expression).

Note that recursiveness is a property of the whole with statement. You cannot have recursive and non-recursive CTEs in a same with statement. Therefore the recursiveness is determined by the first with or withRecusive call you make.

See the {@link with} method for examples and more documentation.

Type Parameters

N extends string
E extends RecursiveCommonTableExpression<DB, N>

Parameters

nameOrBuilder: N | CTEBuilderCallback<N>
expression: E

Returns

QueryCreatorWithCommonTableExpression<DB, N, E>