From c0b3911602064bb303172c547bf7491b1e34afd3 Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Wed, 3 Jul 2013 21:49:04 +0200 Subject: README: fix example query for hash BLOBs Otherwise the sqlite tool just outputs them as binary to the terminal. --- README | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/README b/README index a5ce9d7..c21a50c 100644 --- a/README +++ b/README @@ -39,7 +39,7 @@ Finding the 100 largest files shared with multiple packages. Finding those top 100 files that save most space when being reduced to only one copy in the archive. - SELECT hash, sum(size)-min(size), count(*), count(distinct package) FROM content JOIN hash ON content.id = hash.cid WHERE hash.function = "sha512" GROUP BY hash ORDER BY sum(size)-min(size) DESC LIMIT 100; + SELECT quote(hash), sum(size)-min(size), count(*), count(distinct package) FROM content JOIN hash ON content.id = hash.cid WHERE hash.function = "sha512" GROUP BY hash ORDER BY sum(size)-min(size) DESC LIMIT 100; Finding PNG images that do not carry a .png file extension. -- cgit v1.2.3