select * from depesz;

Friend of mine found something that he thought looked like a bug in Pg.

Very simple query:

select * from table where id not in (select field from other_table)

was not returning any rows, despite the fact that there definitely are some “ids” that are not in other_table.field. Why is that?

- MORE -

On 29th of July, Tom Lane committed patch written by David E. Wheeler, which added new contrib module: citext.

- MORE -

During last month or so, Tom Lane commited changes in PostgreSQL, which were foundations for adding hash-based versions of popular features.

I already described first such feature - DISTINCT.

Now, there were 3 more commits which were related to this:

- MORE -

Cezio wrote post about removing elements from arrays in PostgreSQL.

Unfortunately his blog engine requires registration before comment, which I don’t like, so I decided to comment using my own blogspace.

- MORE -

Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate - just like GROUP BY.

- MORE -

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

- MORE -

Having new VARIADIC functions, I decided it would be cool to be able to write sprintf() function.

Basically the idea is simple, plperl function, which takes “format”, and list of arguments and returns generated output.

- MORE -

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.

- MORE -

Gregory Stark wrote, and Bruce Momjian committed (on 14th of July) patch which shows storage type in psql.

- MORE -

On 15th of July, Bruce Momjian commited patch written by Dickson S. Guedes, which:

Have psql \d show the value of sequence columns.

- MORE -