Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL

Index

A, B

Aggregates

rollingState/rollingValue

AVG() function

COUNT()/FILTER() operations

COUNT/FILTER statements

CREATE AGGREGATE

data type

final function

flexibility/control statement

GROUP BY clause

key features

pictorial representation

state_trans_func_max

state transition function

SUM, MAX, MIN, and AVG

Arrays

append elements

declaration

dims function

FOR loop

iterate

key features

length function

merge

multidimensional arrays

one/zero-based index

remove duplicate elements

single- and multidimensional arrays

source code

square brackets

C

Casting consistency

castcontext

castfunc

castmethod

casttarget

conversion function

CREATE CAST command

data types

implicit type casting

JSONB

key features

pg_cast

pg_cast catalog table

pg_class table

regclass ...