Handy PostgreSQL examples
Quickly count results: Just a count - SELECT COUNT(*) from tablename Count unique entries in table: select count(columnname) from (select distinct columnname from tablename) as x; Create a new table…
Quickly count results: Just a count - SELECT COUNT(*) from tablename Count unique entries in table: select count(columnname) from (select distinct columnname from tablename) as x; Create a new table…
Broadcasting is an interesting word. The 'casting' part is taken from fishing, where one casts a net the purpose of which is to catch many fish at the same time,…
Top it news story is that Twitter is refusing to deliver user data to a USA criminal court. The New York court case involves Malcolm Harris who is being criminally…
Google sponsored initiative, NewMe held a demonstration at Google offices in San Francisco where they demonstrated how they developed, designed and launched new startup companies. Present at the demo were…
Google vs Oracle a Jury in San Francisco found that Google did infringe on Oracle copyrights. The jury was deadlocked 6 people to 6 people, about whether the infringement constituted…
The good news is that there is no such thing as Internet death, you will probably keep on living forever even if it is only in some very dark and…
The catch of the day is definitely this phish: Received: from localhost (localhost.localdomain [127.0.0.1]) Received: from mail.texxa.net (ns1.personalcomputer.net [173.184.121.2]) Received: from User (unknown [184.22.45.176]) by mail.texxa.net (Postfix) with ESMTP id…
It web published an article saying that Google search makes us stupid. Written by Ivo Vegter it is an opinion piece about Google search making us stupid (yes, in so…
Ever had your eye caught on something circling a drain? The circle gets smaller until the object disappears down the rabbit hole. One thing great cutting edge techno-geeks have in…
LinkedIN paid almost the same price for Slideshare than the Scream (a painting by Norwegian Edvard Munch) that sold on auction yesterday for R927,6 million (to a Qatar national) LinkedIn…