March 2008 – Page 2 – select * from depesz;

smtp + sql = more than it seems so (part 8)

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.