Today we have two interesting patches:
Continue reading Waiting for 8.4 – partial-match support in GIN, and sequence restart
Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:
Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).
Today we have one new feature – extension of plpgsql's RAISE command.
Friend from my previous employer told me that plans of execution of prepared statement, and the same statement run “as it" are different.
Well, I checked and this is what I found (it's not shocking, it's actually quite obvious, but You have to think about it for a while to “get it").
Today I will describe 2 new patches which modify psql:
Continue reading Waiting for 8.4 – psql vs. tabs + wrapped output
MySQL has this nifty/annoying feature/bug of special data type “TIMESTAMP". It is like a DATETIME, but it gets automatically updated whenever you modify the row.
I'll try to add the same feature to PostgreSQL.
PostgreSQL 8.3 brought us many great new features. Among them were concurrent autovacuum, enums, tsearch in core.
On of the changes though made a lot of people dislike 8.3. It was removal of implicit casts.
Continue reading “ERROR: operator does not exist: integer = text" how to fix it?
3 new functionalities from 3 people:
Today another two new additions to PostgreSQL – as You can see may commit-fest seems to work pretty good 🙂
Continue reading Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction