Pavel Stehule - hero for everybody writing stored procedures, wrote, and later Tom Lane committed patch which adds named arguments for functions: Log Message: ----------- Support use of function argument names to identify which actual arguments match which function parameters. The syntax uses ...

On 4th of December Peter Eisentraut committed patch by Pavel Stehule (with Peters tweaks) which adds default values for function arguments: Default values for function arguments   Pavel Stehule, with some tweaks by Peter Eisentraut

Today, on #postgresql on IRC, guy (can't contact him now to get his permission to name him), said: I have a table called problematic_hostnames. It contains a list of banned hostnames in column "hostname" (varchar). I would like to display the ...

In PostgreSQL 8.2, we got "RETURNING" clause in INSERT/UPDATE/DELETE queries. Unfortunately it could not be used as source of rows for anything in sql. insert into table_backup delete from table where ... returning *; Well, it's still not possible, but it is a ...

On 28th of October Tom Lane committed his patch that changes some internals of functions, but it also adds interesting capability.

Today, Tom Lane committed patch, written by Abhijit Menon-Sen, which adds interesting feature to psql. Namely - it simplifies changing definition of functions.

Pavel Stehule wrote, and Tom Lane committed patch which ads new syntax for set-returning functions: "RETURNS TABLE".

Pavel Stehule wrote, and then Tom Lane committed (on 16th of July), patch which adds to PostgreSQL support for functions with variable number of arguments.

Every now and then I see people ask the question - how to create table if it doesn't exist yet, how to drop it, but only if it does exist and so on. Well, starting from 8.2 dropping should be not ...

Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).