Major milestone, our MIS migration has completed!

Posted by Adrian on Aug 20, 2008 in business, Open Source, Postgresql | 3 comments I am about 6 days late in posting this, but I am exceptionally proud to say that we completed the major piece of work in our migration on Wednesday last week when we went live with our new php/postregsql MIS system. I am very pleased with it, as FINALLY we are not dependent on MS to run our core business management information system. Top give you some idea of this achievement for us… We...
read more

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