Today we have one new feature – extension of plpgsql's RAISE command.
Author: depesz
Prepared statements gotcha
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").
Waiting for 8.4 – psql vs. tabs + wrapped output
Today I will describe 2 new patches which modify psql:
Continue reading Waiting for 8.4 – psql vs. tabs + wrapped output
MySQL’s timestamp in PostgreSQL
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.
“ERROR: operator does not exist: integer = text” how to fix it?
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?
Waiting for 8.4 – pg_conf_load_time, time-related generate_series and enum values in \dT+
3 new functionalities from 3 people:
Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction
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
Waiting for 8.4 – \o and \d+ in psql
Today, we have 2 new changes in psql. One of them is not actually new feature, but I decided to write about it anyway, because of its implications.
What does “success” mean to You?
Friend from my previous job asked this question: “What does success mean to You"?
One of the answers that I remember he got was:
“Get “brand recognition" of my name, and get a job with monthly salary of 40,000 PLN."
(I'm not sure if “brand recognition" is correct phrase – I mean that he wanted his name/person to be well known among people working in the same area as he is.
40,000 PLN – to give some perspective, is a bit over 10% of value of new Jaguar XK convertible (not XKR).
I would like to ask You, to tell me what does “success" mean to You. What would You have to achieve to feel successful.
Waiting for 8.4 – generate_subscripts
Yesterday, Alvaro Herrera committed patch written by Pavel Stehule which adds generate_subscripts(…) function.