From 796eeb217e449234b777512451c5b668837c9118 Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Thu, 25 Jul 2013 12:48:45 +0200 Subject: README: foo.PNG is also a valid png name --- README | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/README b/README index a023d0a..c749a86 100644 --- a/README +++ b/README @@ -47,7 +47,7 @@ one copy in the archive. Finding PNG images that do not carry a .png file extension. - SELECT package.name, content.filename, content.size FROM content JOIN hash ON content.id = hash.cid JOIN package ON content.pid = package.id WHERE function = "image_sha512" AND filename NOT LIKE "%.png"; + SELECT package.name, content.filename, content.size FROM content JOIN hash ON content.id = hash.cid JOIN package ON content.pid = package.id WHERE function = "image_sha512" AND lower(filename) NOT LIKE "%.png"; Finding .gz files which either are not gziped or contain errors. -- cgit v1.2.3