GitHub

A collection of SQL queries for PostgreSQL, covering filtering, aggregation, window ...

Basic Query Operations (Filtering, Sorting, Grouping) Aggregate Functions (SUM, COUNT, MAX, MIN) Window Functions (RANK, DENSE_RANK, LEAD, LAG) Joins (INNER, LEFT ...
InfoQ

High Performance Functions in Rust on RDS PostgreSQL

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
GitHub

PostgreSQL Functions With BEGIN ATOMIC is not supported: ERROR: syntax error at end of input

PostgreSQL 14 added support for SQL-standard bodies in funcs and procs that are using BEGIN ATOMIC clauses. This function creation statement doesn't work in DBeaver: CREATE OR REPLACE FUNCTION ...
www.cs.cmu.edu

19.10. Examples

Here are only a few functions to demonstrate how easy it is to write PL/pgSQL functions. For more complex examples the programmer might look at the regression test for PL/pgSQL.