In the 1980 comments were used to reduce the “gap” between unstructured code and “rationale” behind the code. C/64 Peek and poke where oscure. Gosub on function pointed by numbers was bad 8-bit systems was tight on command names and so on (think to write a python interpreter in Arduino/bbc:Micro, or look at the memory …
Oracle trick: [sql] DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3); [/sql] Postgresql equivalent is ctid, so you can try something like [sql] delete from mytable where exists (select 1 from mytable t2 where t2.name = mytable.name and t2.address = mytable.address and t2.zip = mytable.zip and t2.ctid …
Removing duplicate rows in PostgreSQL and Oracle Read More »
I have used Google in the past 8 years (I know, I am a bit old). Then I was annoyed because of a bad behavior of Google with my AdSense account (shutdown without being able to talk back to someone for explanation). In the last month I tried Bing and I was happy with it. …
Steve is not a normal solution provider.
Steve is the final destination for Project Management troubles.
Let’s see how Steve can solve problems
