Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL is called ctid, as we shall see:

Read More

In Excel you can easily fill in a column with a list of values. Some times also in Emacs you my need to write down a bunch of similar code. The dotimes function with the “elsp eval” M-x : (Esc + : on windooze) will solve your trouble easily. Try out this code on scratch buffer:

Read More