Squeal.PostgreSQL.Expression.SetOf

Set returning functions

Documentation

generateSeries

Arguments

:: ty `In` '[PGint4, PGint8, PGnumeric]

=> SetOfFunctionN "generate_series" '[null ty, null ty] '["generate_series" ::: null ty]

set returning function

generateSeries (start *: stop)

Generate a series of values, from start to stop with a step size of one

generateSeriesStep

Arguments

:: ty `In` '[PGint4, PGint8, PGnumeric]

=> SetOfFunctionN "generate_series" '[null ty, null ty, null ty] '["generate_series" ::: null ty]

set returning function

generateSeries (start :* stop *: step)

Generate a series of values, from start to stop with a step size of step

generateSeriesTimestamp

Arguments

:: ty `In` '[PGtimestamp, PGtimestamptz]

=> SetOfFunctionN "generate_series" '[null ty, null ty, null PGinterval] '["generate_series" ::: null ty]

set returning function

generateSeries (start :* stop *: step)

Generate a series of values, from start to stop with a step size of step

type SetOfFunction fun ty setof

Arguments

 = Expression outer commons Ungrouped schemas params '[] ty

input

-> FromClause outer commons schemas params '[fun ::: setof]

output

A RankNType for set returning functions with 1 argument.

unsafeSetOfFunction

Arguments

:: KnownSymbol fun

=> SetOfFunction fun ty setof

set returning function

Escape hatch for a set returning function with 1 argument.

type SetOfFunctionN fun tys setof

Arguments

 = NP (Expression outer commons Ungrouped schemas params '[]) tys

inputs

-> FromClause outer commons schemas params '[fun ::: setof]

output

A RankNType for set returning functions with multiple argument.

unsafeSetOfFunctionN

Arguments

:: (SListI tys, KnownSymbol fun)

=> SetOfFunctionN fun tys setof

set returning function

Escape hatch for a set returning function with multiple argument.