postgres.core — xyz.zcaudate/postgres 4.1.8

+array+ clj

+bit+ clj

+current+ clj

+functions+ clj

+has+ clj

+jsonb+ clj

+math+ clj

+pgjwt+ clj

+regexp+ clj

+xml+ clj

abs clj

acos clj

acosd clj

acosh clj

app clj

(app)

(app name)

gets an app

app-clear clj

(app-clear name)

clears the entry for an app

app-create clj

(app-create name & [public-only])

makes the app graph schema

app-list clj

(app-list)

rebuilds the app schema

app-rebuild clj

(app-rebuild name)

rebuilds the app schema

app-schema clj

(app-schema name)

gets the app schema

app-typed clj

(app-typed name)

gets the app typed payload

ARRAY clj

(ARRAY & args)

creates an array

array-agg clj

array-append clj

array-cat clj

array-dims clj

array-eq clj

array-fill clj

array-ge clj

array-gt clj

array-in clj

array-larger clj

array-le clj

array-length clj

array-lower clj

array-lt clj

array-ndims clj

array-ne clj

array-out clj

array-position clj

array-positions clj

array-prepend clj

array-recv clj

array-remove clj

array-replace clj

array-send clj

array-smaller clj

array-to-json clj

array-to-string clj

array-to-tsvector clj

array-typanalyze clj

array-unnest-support clj

array-upper clj

ascii clj

asin clj

asind clj

asinh clj

assert clj

(assert chk [tag data])

asserts given a block

atan clj

atan2 clj

atan2d clj

atand clj

atanh clj

b:delete clj

(b:delete & args)

delete macro

b:insert clj

(b:insert & args)

insert macro

b:select clj

(b:select & args)

basic select macro

b:update clj

(b:update & args)

update macro

bind-app clj

(bind-app app & [update-key])

gets the app interface given a name

bind-schema clj

(bind-schema schema & [excluded])

binds a schema

bit clj

bit-and clj

bit-length clj

bit-or clj

bitand clj

bitcat clj

bitcmp clj

biteq clj

bitge clj

bitgt clj

bitle clj

bitlt clj

bitne clj

bitnot clj

bitor clj

bitshiftleft clj

bitshiftright clj

bitxor clj

bool-and clj

bool-or clj

btrim clj

case clj

(case & args)

builds a case form

cbrt clj

ceil clj

ceiling clj

chr clj

client-list clj

(client-list)

gets the client list for pg

coalesce clj

collate clj

concat-ws clj

connectby clj

coord clj

(coord table row-id)

gets the coordinate of a row

corr clj

cos clj

cosd clj

cosh clj

cot clj

cotd clj

count clj

covar-pop clj

covar-samp clj

crosstab clj

crosstab2 clj

crosstab3 clj

crosstab4 clj

crypt clj

cume-dist clj

current-database clj

current-query clj

current-schema clj

current-schemas clj

current-setting clj

current-user clj

currval clj

cursor-to-xml clj

cursor-to-xmlschema clj

database-to-xml clj

database-to-xml-and-xmlschema clj

database-to-xmlschema clj

decode clj

decrypt clj

defret.pg clj macro

(defret.pg sym args query)

creates a returns function

defsel.pg clj macro

(defsel.pg sym & [query])

creates a select function

defvariant.pg clj macro

(defvariant.pg table selector field)

Declares a class-table-specific JSONB field contract.

The declaration is metadata only. It emits no PostgreSQL code; typed parsers and repository tooling retain the source form for validation and class-table-aware shape inference.

degrees clj

dense-rank clj

digest clj

div clj

do:plpgsql clj

(do:plpgsql & forms)

creates a do block

do:reduce clj

(do:reduce out f type arr)

basic reduce macro

E clj

(E {:keys [application] :as m})

encode clj

encrypt clj

enum-first clj

enum-last clj

enum-range clj

error clj

(error {:as m})

raises a json error with value

every clj

exec clj

(exec args)

executes an sql statement

exists clj

exp clj

extract clj

factorial clj

field-id clj

(field-id m field)

shorthand for getting the field-id for a linked map

first-value clj

floor clj

format clj

full clj

(full table)

gets the full jsonb for table or function

full-str clj

(full-str table)

gets the full json str form table or function

g:count clj

(g:count spec-sym &)

gets only count

g:delete clj

(g:delete spec-sym &)

constructs the delete form

g:exists clj

(g:exists spec-sym &)

TODO

g:get clj

(g:get spec-sym &)

gets a single entry

g:id clj

(g:id spec-sym &)

gets only id

g:insert clj

(g:insert spec-sym data & [params])

constructs an insert form

g:modify clj

(g:modify spec-sym &)

constructs the modify form

g:select clj

(g:select spec-sym &)

returns matching entries

g:update clj

(g:update spec-sym &)

constructs the update form

g:where clj

(g:where spec-sym where)

TODO

gcd clj

gen-random-bytes clj

gen-random-uuid clj

gen-salt clj

generate-series clj

generate-subscripts clj

get-bit clj

get-stack-diagnostics clj

(get-stack-diagnostics)

gets the stack diagnostics

grouping clj

has-any-column-privilege clj

has-column-privilege clj

has-database-privilege clj

has-foreign-data-wrapper-privilege clj

has-function-privilege clj

has-language-privilege clj

has-schema-privilege clj

has-sequence-privilege clj

has-server-privilege clj

has-table-privilege clj

has-tablespace-privilege clj

has-type-privilege clj

hmac clj

id clj

(id sym & [type])

gets the id of an object

initcap clj

isempty clj

jsonb-agg clj

jsonb-array-elements clj

jsonb-array-elements-text clj

jsonb-array-length clj

jsonb-build-array clj

jsonb-build-object clj

jsonb-cmp clj

jsonb-concat clj

jsonb-contained clj

jsonb-contains clj

jsonb-delete clj

jsonb-delete-path clj

jsonb-each clj

jsonb-each-text clj

jsonb-eq clj

jsonb-exists clj

jsonb-exists-all clj

jsonb-exists-any clj

jsonb-extract-path clj

jsonb-extract-path-text clj

jsonb-ge clj

jsonb-gt clj

jsonb-hash clj

jsonb-hash-extended clj

jsonb-in clj

jsonb-insert clj

jsonb-le clj

jsonb-lt clj

jsonb-ne clj

jsonb-object clj

jsonb-object-agg clj

jsonb-object-agg-finalfn clj

jsonb-object-agg-transfn clj

jsonb-object-field clj

jsonb-object-field-text clj

jsonb-object-keys clj

jsonb-out clj

jsonb-path-exists clj

jsonb-path-exists-opr clj

jsonb-path-exists-tz clj

jsonb-path-match clj

jsonb-path-match-opr clj

jsonb-path-match-tz clj

jsonb-path-query clj

jsonb-path-query-array clj

jsonb-path-query-array-tz clj

jsonb-path-query-first clj

jsonb-path-query-first-tz clj

jsonb-path-query-tz clj

jsonb-populate-record clj

jsonb-populate-recordset clj

jsonb-pretty clj

jsonb-recv clj

jsonb-send clj

jsonb-set clj

jsonb-set-lax clj

jsonb-strip-nulls clj

jsonb-to-record clj

jsonb-to-recordset clj

jsonb-to-tsvector clj

jsonb-typeof clj

lag clj

last-value clj

lastval clj

lcm clj

lead clj

left clj

length clj

ln clj

log clj

log10 clj

lower clj

lower-inc clj

lower-inf clj

lpad clj

ltrim clj

make-time clj

make-timestamp clj

map:js clj

(map:js f arr & args)

basic map across json

map:js-text clj

(map:js-text f arr & args)

maps across json

map:rel clj

(map:rel f rel & args)

basic map across relation

max clj

md5 clj

min clj

mod clj

mode clj

name clj

(name table)

gets the name of a table

nextval clj

normal-rand clj

now clj

nth-value clj

ntile clj

octet-length clj

overlay clj

parse-ident clj

percent-rank clj

percentile-cont clj

percentile-disc clj

perform clj

(perform & args)

perform macro

pg-tmpl clj

(pg-tmpl sym)

creates fragments in builtin

pi clj

position clj

pow clj

q clj

(q spec-sym &)

constructs a query form

q:get clj

(q:get spec-sym &)

constructs a single query form

query-to-xml clj

query-to-xml-and-xmlschema clj

query-to-xmlschema clj

quote-ident clj

quote-literal clj

quote-nullable clj

radians clj

rand-hex clj

(rand-hex n)

generates random hex

random clj

random-enum clj

(random-enum enum)

gets random enum

range-merge clj

rank clj

regexp-match clj

regexp-matches clj

regexp-replace clj

regexp-split-to-array clj

regexp-split-to-table clj

regr-avgx clj

regr-avgy clj

regr-count clj

regr-intercept clj

regr-r2 clj

regr-slope clj

regr-sxx clj

regr-sxy clj

regr-syy clj

repeat clj

replace clj

ret clj

(ret & args)

returns a value alias for select

rollup clj

round clj

row-number clj

rpad clj

rtrim clj

scale clj

schema-to-xml clj

schema-to-xml-and-xmlschema clj

schema-to-xmlschema clj

set-bit clj

set-config clj

setseed clj

setval clj

sha1 clj

(sha1 text)

calculates the sha1

sign clj

sin clj

sind clj

sinh clj

split-part clj

sqrt clj

starts-with clj

stddev clj

stddev-pop clj

stddev-samp clj

string-agg clj

string-to-array clj

strpos clj

substr clj

substring clj

sum clj

t:count clj

(t:count spec-sym &)

get count entry

t:delete clj

(t:delete spec-sym &)

flat delete

t:exists clj

(t:exists spec-sym &)

TODO

t:fields clj

(t:fields spec-sym &)

gets the fields

t:get clj

(t:get spec-sym &)

get single entry

t:get-field clj

(t:get-field spec-sym &)

gets single field

t:id clj

(t:id spec-sym &)

get id entry

t:insert clj

(t:insert spec-sym data &)

flat insert

t:insert! clj

(t:insert! spec-sym data &)

inserts without o-op

t:modify clj

(t:modify spec-sym &)

flat modify

t:select clj

(t:select spec-sym &)

flat select

t:update clj

(t:update spec-sym &)

flat update

t:update! clj

(t:update! spec-sym &)

updates with o-op

t:upsert clj

(t:upsert spec-sym data &)

flat upsert

table-to-xml clj

table-to-xml-and-xmlschema clj

table-to-xmlschema clj

tan clj

tand clj

tanh clj

throw clj

(throw {:as m})

raises a json exception

time-ms clj

(time-ms)

returns the time in ms

time-us clj

(time-us)

returns the time in us

timeofday clj

to-ascii clj

to-char clj

to-date clj

to-hex clj

to-jsonb clj

to-number clj

to-timestamp clj

translate clj

trim clj

trunc clj

tsvector-to-array clj

unnest clj

upper clj

upper-inc clj

upper-inf clj

uuid-generate-v1 clj

uuid-generate-v1mc clj

uuid-generate-v4 clj

uuid-nil clj

var-pop clj

var-samp clj

variance clj

verify clj

view clj

(view qret qsel & [qopts])

constructs a view form

xml clj

xml-is-well-formed clj

xml-is-well-formed-content clj

xml-is-well-formed-document clj

xmlagg clj

xmlcomment clj

xmlconcat2 clj

xmlexists clj

xmlvalidate clj