hara.runtime.postgres
+array+
+bit+
+current+
+functions+
+has+
+jsonb+
+math+
+pgjwt+
+regexp+
+xml+
abs
acos
acosd
acosh
ARRAY
added in 4.0
(ARRAY & args)creates an array
array-agg
array-append
array-cat
array-dims
array-eq
array-fill
array-ge
array-gt
array-in
array-larger
array-le
array-length
array-lower
array-lt
array-ndims
array-ne
array-out
array-position
array-positions
array-prepend
array-recv
array-remove
array-replace
array-send
array-smaller
array-to-json
array-to-string
array-to-tsvector
array-typanalyze
array-unnest-support
array-upper
ascii
asin
asind
asinh
assert
added in 4.0
(assert chk [tag data])asserts given a block
atan
atan2
atan2d
atand
atanh
b:delete
added in 4.0
(b:delete & args)delete macro
b:insert
added in 4.0
(b:insert & args)insert macro
b:select
added in 4.0
(b:select & args)basic select macro
b:update
added in 4.0
(b:update & args)update macro
bind-app
added in 4.0
(bind-app app & [update-key])gets the app interface given a name
bind-entry
added in 4.1
(bind-entry ptr)gets a materialized postgres code entry when available
bind-function
added in 4.0
(bind-function ptr)generates the type signatures for a pg function
bind-schema
added in 4.0
(bind-schema schema & [excluded])binds a schema
bind-table
added in 4.0
(bind-table ptr & [update-key])gets the table interface
bind-view
added in 4.0
(bind-view ptr & [opts])generates the view interface
bind-view-guards
added in 4.0
(bind-view-guards guards)gets more guards
bit
bit-and
bit-length
bit-or
bitand
bitcat
bitcmp
biteq
bitge
bitgt
bitle
bitlt
bitne
bitnot
bitor
bitshiftleft
bitshiftright
bitxor
bool-and
bool-or
btrim
case
added in 4.0
(case & args)builds a case form
cbrt
ceil
ceiling
chr
client-list
added in 4.0
(client-list)gets the client list for pg
coalesce
collate
concat-ws
connectby
coord
added in 4.0
(coord table row-id)gets the coordinate of a row
corr
cos
cosd
cosh
cot
cotd
count
covar-pop
covar-samp
crosstab
crosstab2
crosstab3
crosstab4
crypt
cume-dist
current-database
current-query
current-schema
current-schemas
current-setting
current-user
currval
cursor-to-xml
cursor-to-xmlschema
database-to-xml
database-to-xml-and-xmlschema
database-to-xmlschema
decode
decrypt
defret.pg
macro
added in 4.0
(defret.pg sym args query)creates a returns function
defsel.pg
macro
added in 4.0
(defsel.pg sym & [query])creates a select function
degrees
dense-rank
digest
div
do:plpgsql
added in 4.0
(do:plpgsql & forms)creates a do block
do:reduce
added in 4.0
(do:reduce out f type arr)basic reduce macro
E
(E {:keys [application], :as m})encode
encrypt
enum-first
enum-last
enum-range
error
added in 4.0
(error {:as m})raises a json error with value
every
exec
added in 4.0
(exec args)executes an sql statement
exists
exp
extract
factorial
field-id
added in 4.0
(field-id m field)shorthand for getting the field-id for a linked map
first-value
floor
format
full
added in 4.0
(full table)gets the full jsonb for table or function
full-str
added in 4.0
(full-str table)gets the full json str form table or function
g:count
added in 4.0
(g:count spec-sym &)gets only count
g:delete
added in 4.0
(g:delete spec-sym &)constructs the delete form
g:exists
added in 4.0
(g:exists spec-sym &)TODO
g:get
added in 4.0
(g:get spec-sym &)gets a single entry
g:id
added in 4.0
(g:id spec-sym &)gets only id
g:insert
added in 4.0
(g:insert spec-sym data & [params])constructs an insert form
g:modify
added in 4.0
(g:modify spec-sym &)constructs the modify form
g:select
added in 4.0
(g:select spec-sym &)returns matching entries
g:update
added in 4.0
(g:update spec-sym &)constructs the update form
g:where
added in 4.0
(g:where spec-sym where)TODO
gcd
gen-random-bytes
gen-random-uuid
gen-salt
generate-series
generate-subscripts
get-bit
get-stack-diagnostics
added in 4.0
(get-stack-diagnostics)gets the stack diagnostics
grouping
has-any-column-privilege
has-column-privilege
has-database-privilege
has-foreign-data-wrapper-privilege
has-function-privilege
has-language-privilege
has-schema-privilege
has-sequence-privilege
has-server-privilege
has-table-privilege
has-tablespace-privilege
has-type-privilege
hmac
id
added in 4.0
(id sym & [type])gets the id of an object
initcap
invoke-ptr-pg
added in 4.0
(invoke-ptr-pg {:keys [instance], :as pg} ptr args)invokes a pointer in runtime
isempty
jsonb-agg
jsonb-array-elements
jsonb-array-elements-text
jsonb-array-length
jsonb-build-array
jsonb-build-object
jsonb-cmp
jsonb-concat
jsonb-contained
jsonb-contains
jsonb-delete
jsonb-delete-path
jsonb-each
jsonb-each-text
jsonb-eq
jsonb-exists
jsonb-exists-all
jsonb-exists-any
jsonb-extract-path
jsonb-extract-path-text
jsonb-ge
jsonb-gt
jsonb-hash
jsonb-hash-extended
jsonb-in
jsonb-insert
jsonb-le
jsonb-lt
jsonb-ne
jsonb-object
jsonb-object-agg
jsonb-object-agg-finalfn
jsonb-object-agg-transfn
jsonb-object-field
jsonb-object-field-text
jsonb-object-keys
jsonb-out
jsonb-path-exists
jsonb-path-exists-opr
jsonb-path-exists-tz
jsonb-path-match
jsonb-path-match-opr
jsonb-path-match-tz
jsonb-path-query
jsonb-path-query-array
jsonb-path-query-array-tz
jsonb-path-query-first
jsonb-path-query-first-tz
jsonb-path-query-tz
jsonb-populate-record
jsonb-populate-recordset
jsonb-pretty
jsonb-recv
jsonb-send
jsonb-set
jsonb-set-lax
jsonb-strip-nulls
jsonb-to-record
jsonb-to-recordset
jsonb-to-tsvector
jsonb-typeof
lag
last-value
lastval
lcm
lead
left
length
list-all
added in 4.0
(list-all ns)lists all function forms
list-api
added in 4.0
(list-api ns & [pred])lists all apis
list-debug
added in 4.0
(list-debug ns & [pred])lists all debug apis
list-view
added in 4.0
(list-view ns type)lists all views in the schema
ln
log
log10
lower
lower-inc
lower-inf
lpad
ltrim
make-time
make-timestamp
map:js
added in 4.0
(map:js f arr & args)basic map across json
map:js-text
added in 4.0
(map:js-text f arr & args)maps across json
map:rel
added in 4.0
(map:rel f rel & args)basic map across relation
max
md5
min
mod
mode
name
added in 4.0
(name table)gets the name of a table
nextval
normal-rand
now
nth-value
ntile
octet-length
overlay
parse-ident
percent-rank
percentile-cont
percentile-disc
perform
added in 4.0
(perform & args)perform macro
pg-tmpl
added in 4.0
(pg-tmpl sym)creates fragments in builtin
pi
plain-symbol?
(plain-symbol? form)position
pow
purge-postgres
added in 4.0
(purge-postgres)purges the postgres.core library. Used for debugging
purge-scratch
added in 4.0
(purge-scratch)purges the postgres.core scratch library. Used for debugging
q
added in 4.0
(q spec-sym &)constructs a query form
q:get
added in 4.0
(q:get spec-sym &)constructs a single query form
query-to-xml
query-to-xml-and-xmlschema
query-to-xmlschema
quote-ident
quote-literal
quote-nullable
radians
rand-hex
added in 4.0
(rand-hex n)generates random hex
random
random-enum
added in 4.0
(random-enum enum)gets random enum
range-merge
rank
raw-eval-pg
added in 4.0
(raw-eval-pg {:keys [instance], :as rt} body)executes a raw value
regexp-match
regexp-matches
regexp-replace
regexp-split-to-array
regexp-split-to-table
regr-avgx
regr-avgy
regr-count
regr-intercept
regr-r2
regr-slope
regr-sxx
regr-sxy
regr-syy
repeat
replace
ret
added in 4.0
(ret & args)returns a value alias for select
rollup
round
row-number
rpad
rt-add-notify
added in 4.0
(rt-add-notify {:keys [notifications], :as pg} id {:keys [channel on-close on-notify], :as m})adds a notification channel
rt-list-notify
added in 4.0
(rt-list-notify {:keys [notifications]})lists all notification channels
rt-postgres
added in 4.0
(rt-postgres)(rt-postgres m)creates and startn a postgres runtime
rt-remove-notify
added in 4.0
(rt-remove-notify {:keys [notifications]} id)removes a notification channel
rtrim
scale
schema-to-xml
schema-to-xml-and-xmlschema
schema-to-xmlschema
set-bit
set-config
setseed
setval
sha1
added in 4.0
(sha1 text)calculates the sha1
sign
sin
sind
sinh
split-part
sqrt
starts-with
stddev
stddev-pop
stddev-samp
string-agg
string-to-array
strpos
substr
substring
sum
t:count
added in 4.0
(t:count spec-sym &)get count entry
t:delete
added in 4.0
(t:delete spec-sym &)flat delete
t:exists
added in 4.0
(t:exists spec-sym &)TODO
t:fields
added in 4.0
(t:fields spec-sym &)gets the fields
t:get
added in 4.0
(t:get spec-sym &)get single entry
t:get-field
added in 4.0
(t:get-field spec-sym &)gets single field
t:id
added in 4.0
(t:id spec-sym &)get id entry
t:insert
added in 4.0
(t:insert spec-sym data &)flat insert
t:insert!
added in 4.0
(t:insert! spec-sym data &)inserts without o-op
t:modify
added in 4.0
(t:modify spec-sym &)flat modify
t:select
added in 4.0
(t:select spec-sym &)flat select
t:update
added in 4.0
(t:update spec-sym &)flat update
t:update!
added in 4.0
(t:update! spec-sym &)updates with o-op
t:upsert
added in 4.0
(t:upsert spec-sym data &)flat upsert
table-to-xml
table-to-xml-and-xmlschema
table-to-xmlschema
tan
tand
tanh
throw
added in 4.0
(throw {:as m})raises a json exception
time-ms
added in 4.0
(time-ms)returns the time in ms
time-us
added in 4.0
(time-us)returns the time in us
timeofday
to-ascii
to-char
to-date
to-hex
to-jsonb
to-lookup
(to-lookup arr)to-number
to-timestamp
transform-query
added in 4.0
(transform-query query & [sym-pred])generates the query interface
transform-query-classify
added in 4.0
(transform-query-classify form)transform function and quote representations
transform-query-or
added in 4.0
(transform-query-or form)transforms a setvec form
transform-schema
added in 4.0
(transform-schema schema)transforms the schema
transform-to-str
added in 4.0
(transform-to-str x)transforms relevant forms to string
translate
trim
trunc
tsvector-to-array
unnest
upper
upper-inc
upper-inf
uuid-generate-v1
uuid-generate-v1mc
uuid-generate-v4
uuid-nil
var-pop
var-samp
variance
verify
view
added in 4.0
(view qret qsel & [qopts])constructs a view form