February 13th, 2012 by depesz | Tags: , , , , , | Comments Off on Waiting for 9.2 – Named parameters in SQL functions

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

December 9th, 2008 by depesz | Tags: , , , , , , | Comments Off on Waiting for 8.4 – Default values for function arguments + integer in any base

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

November 3rd, 2008 by depesz | Tags: , , , , | Comments Off on Waiting for 8.4 – sql-wrappable RETURNING

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