New posts in plpgsql

Store select query's output in one array in postgres

sql arrays postgresql plpgsql

How do I do large non-blocking updates in PostgreSQL?

postgresql transactions sql-update plpgsql dblink

Return multiple fields as a record in PostgreSQL with PL/pgSQL

sql postgresql stored-procedures types plpgsql

PostgreSQL parameterized Order By / Limit in table function

sql database postgresql dynamic-sql plpgsql

PL/pgSQL checking if a row exists

sql postgresql plpgsql postgresql-9.1 exists

How to set value of composite variable field using dynamic SQL

postgresql stored-procedures types composite plpgsql

Return rows matching elements of input array in plpgsql function

arrays postgresql aggregate-functions plpgsql postgresql-9.2

PostgreSQL: ERROR: 42601: a column definition list is required for functions returning "record"

postgresql parameter-passing plpgsql set-returning-functions

GROUP BY and aggregate sequential numeric values

sql postgresql plpgsql window-functions gaps-and-islands

How to create function that returns nothing

postgresql function plpgsql void

Pass multiple values in single parameter

sql postgresql stored-procedures parameter-passing plpgsql

Define table and column names as arguments in a plpgsql function?

function postgresql variables plpgsql dynamic-sql

Unnest multiple arrays in parallel

arrays postgresql arraylist plpgsql set-returning-functions

Store query result in a variable using in PL/pgSQL

database postgresql stored-procedures plpgsql postgresql-9.1

Truncating all tables in a Postgres database

postgresql plpgsql dynamic-sql truncate database-table

How to return result of a SELECT inside a function in PostgreSQL?

sql postgresql return plpgsql return-type

INSERT with dynamic table name in trigger function

postgresql triggers dynamic-sql plpgsql

What are '$$' used for in PL/pgSQL

postgresql plpgsql quotes dollar-sign dollar-quoting

The forgotten assignment operator "=" and the commonplace ":="

postgresql plpgsql assignment-operator colon-equals

Difference between language sql and language plpgsql in PostgreSQL functions

sql function postgresql stored-procedures plpgsql