select * from depesz;

waiting for pg 8.4

on sunday, 23rd of march, tom lane commited another new-feature patch. this new patch was from brendan jurd, and adds quote_nullable() function:

yesterday, tom lane committed another great feature. actually it's so great, that i really wonder how could i live without it earlier.

patch came from itagaki takahiro, and was heavily modified by tom. what it does?

simple brain teaser:

given standard unix crontab what is the longest possible interval between calls to the same program?

for example:

15 */2 * * * /bin/echo x

has interval 2 hours.

what is the longest possible? and how to make it?

znajomy powiedział mi dziś o jakiejś wtopie mailowej az.pl. z tej okazji wszedłem na ich stronę. i oczom mym ukazała się strona:

there are this situations where you need (or you think you need) to get multiple values from sequence.

for example – you're importing lots of data: some objects, some objects which relate to base objects, and so on.

of course you can do it all with simple inserts, and currval, but it would be rather slow:

last time, i showed how to add automatical filtering of mails. and i told you that i will show another way.

in previous part of this howto we setup autoresponder/vacation system.

additionally i promised to show how to filter user mails.

today (2008-03-10) magnus hagander commited patch which adds new, quite handy functionality: “enum type for guc parameters".

in last part of this howto we did setup pop3/imap client access.

together with things set in all previous parts it makes a fully working mail system.

but, there are still things that might be added/modified. one of these is vacation support …

couple of times is was brought to attention of #postgresql channel – how to find longest prefix.

case: you have phone number, and you want to find which carrier it is bound to.

there are at least 3 ways of finding it, and i decided to take a look at which is fastest.