blob: 565d31aa227001f47a0f2b862df8710799d8af31 (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TEMPORARY TABLE filelist AS
SELECT
r.repoid,
ft.filetypeid,
(STRING_TO_ARRAY(fl.filename, '/'))[2:100] pathparts,
fl.filesize,
fl.filemtime moddate
FROM filelistraw fl, gentoobrowse.repos r, gentoobrowse.filetypes ft
WHERE (STRING_TO_ARRAY(fl.filename, '/'))[1] = r.name
AND (STRING_TO_ARRAY(fl.filename, '/'))[2:100] ~ ft.spec
|
