Postgresql: Calculate work days (none weekend days)

Posted by rich on Feb 15, 2008 in coding, Postgresql | 4 comments Coming from a MsSQL database with access queries/macros/modules and so on, its easy to be able to work out weekend days from two given dates, ie if you have two dates you can calculate how many days between them aren’t weekdays. In postgresql, this isnt so easy! there aren’t many examples on the net, without creating mass functions, but i’ve come up with this: SELECT count(*)...
read more

Postgresql: Converting money type to numeric!

Posted by rich on Feb 14, 2008 in coding, Postgresql | 0 comments Quick post here, as I was having trouble finding any information(that worked, or indepth enough to work for what I needed). The type money is now deprecated from postgresql, and a few of our tables contained this data type. This is fine, and worked as we wanted, until there came a time I needed to do a query such as: select * from mytable where (mytable.charge > 0); seems easy enough, but if...
read more

annoying spam, and issues of packaged SpamAssasin and Zimbra

Posted by Adrian on Feb 10, 2008 in Open Source | 2 comments In the past few days we have started getting an abnormally high volume of spam that has made it way through the packaged SpamAssassin in Zimbra.  Its annoying, as all spam is, but as well as being very easy to configure on a basic level as an inbuilt and integrated package, its annoying when you cannt eeasily click a GUI interface that updates the software without a full upgrade .  We are...
read more