blob: 76d5536d21c19c4e6abf5f667de66988956ed746 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TEMPORARY TABLE filelist AS
SELECT
r.repoid,
fl.filename,
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
|
