Skip to content

Instantly share code, notes, and snippets.

View cmcaine's full-sized avatar

Colin Caine cmcaine

63 followers · 11 following
  • Manchester
View GitHub Profile
@cmcaine
cmcaine / diff-example.sql
Last active September 8, 2023 03:13
Diff SQL Select statements
/*
Show row differences between SELECT statements `new` and `old`.
The first column ("diff") will contain a '+' for rows that are in new and not in old
and a '-' for rows that are in old and not in new. The rest of the columns are whatever
new and old return.
If the rows in new and old share ids, then you may want to add an "ORDER BY" at the end
of the outer SELECT to make the two versions of the rows appear next to each other.
@cmcaine
cmcaine / x.md
Last active June 1, 2024 10:46
"The Center Party wants to shoot all wolves in Norway"

Google translation of https://web.archive.org/web/20130211040508/http://www.nationen.no/2012/09/06/rovdyr/ulv/jakt/rovdyrforlik/fellingtillatelse/7637759/

The Center Party wants to shoot all wolves in Norway

When wolves are released from zoos in Sweden to save the wolf tribe, something is wrong, says Deputy Director of Sp and head of the program committee, Trygve Slagsvold Vedum.

The wolf has been protected in Norway since 1973, but Sp wants to put an end to that. In a submission to the Storting program for the Center Party, the government party advocates free hunting of wolves in Norway.