Database.Esqueleto.PostgreSQL

This module contain PostgreSQL-specific functions.

Since: 2.2.8

Documentation

arrayAgg :: SqlExpr (Value a) -> SqlExpr (Value [a])

(array_agg) Concatenate input values, including NULLs, into an array.

Since: 2.2.8

stringAgg

Arguments

:: SqlString s

=> SqlExpr (Value s)

Input values.

-> SqlExpr (Value s)

Delimiter.

-> SqlExpr (Value s)

Concatenation.

(string_agg) Concatenate input values separated by a delimiter.

Since: 2.2.8

chr :: SqlString s => SqlExpr (Value Int) -> SqlExpr (Value s)

(chr) Translate the given integer to a character. (Note the result will depend on the character set of your database.)

Since: 2.2.11