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