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