On 5th of February, Tom Lane committed patch: Allow SQL-language functions to reference parameters by name. Matthew Draper, reviewed by Hitoshi Harada

Today some guy on IRC asked question, which I didn't fully understand, but which could (probably) be summarized: how to group data into 5 minute intervals, based on some timestamp column. Well, it seems trivial (as long as you know how ...

On 26th of September, Peter Eisentraut committed patch which adds: Add ALTER TYPE ... ADD/DROP/ALTER/RENAME ATTRIBUTE   Like with tables, this also requires allowing the existence of composite types with zero attributes.   reviewed by KaiGai Kohei

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.

September 6th, 2008 by depesz | Tags: , , , , | 2 comments »

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".