Basics

Function Call

PostgreSQL functions are generated from the list inpostgres-functions-list.ts. The generator inextract.ts produces camelCase helpers for each function, while cast-style entries are exposed as toX helpers.

Basics

Call PostgreSQL functions using the generated helpers.

const query = q
  .select(q.lower(q.c("users.email")))
  .from(q.t("users"))

const query = q
  .select(q.lower(q.c("users.email")))
  .from(q.t("users"))

Cast Helpers

Cast-style functions are exposed as toX helpers.

const query = q
  .select(q.toText(q.c("events.payload")))
  .from(q.t("events"))

const query = q
  .select(q.toText(q.c("events.payload")))
  .from(q.t("events"))

Function Index

Complete list of PostgreSQL functions.

Showing 20 of 993

#	Helper	Function	Args	Format
1	abs	ABS	value	CALL
2	cbrt	CBRT	value	CALL
3	ceil	CEIL	value	CALL
4	ceiling	CEILING	value	CALL
5	degrees	DEGREES	value	CALL
6	div	DIV	y, x	CALL
7	erf	ERF	value	CALL
8	erfc	ERFC	value	CALL
9	exp	EXP	value	CALL
10	factorial	FACTORIAL	value	CALL
11	floor	FLOOR	value	CALL
12	gamma	GAMMA	value	CALL
13	gcd	GCD	y, x	CALL
14	lcm	LCM	y, x	CALL
15	lgamma	LGAMMA	value	CALL
16	ln	LN	value	CALL
17	log	LOG	value	CALL
18	log	LOG	base, value	CALL
19	log10	LOG10	value	CALL
20	minScale	MIN_SCALE	value	CALL

Page 1 of 50