diff options
| author | randomdan <randomdan@localhost> | 2010-08-17 19:52:43 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-08-17 19:52:43 +0000 |
| commit | fa65aec465e380763291762bf7bb588e18827f47 (patch) | |
| tree | d4cf1fc670b5cf126ca172e93194ff8e297d5618 /gentoobrowse/views | |
| parent | Add option to use a temporary view instead of a table to reduce WAL churn dur... (diff) | |
| download | gentoobrowse-fa65aec465e380763291762bf7bb588e18827f47.tar.bz2 gentoobrowse-fa65aec465e380763291762bf7bb588e18827f47.tar.xz gentoobrowse-fa65aec465e380763291762bf7bb588e18827f47.zip | |
Tidy up and prettehize
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/package.xml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/gentoobrowse/views/package.xml b/gentoobrowse/views/package.xml index ba5041b..1ed38b3 100644 --- a/gentoobrowse/views/package.xml +++ b/gentoobrowse/views/package.xml @@ -28,9 +28,10 @@ </project2:sqlview> <project2:sqlview name="versions" recordname="version" datasource="postgres"> <sql> - SELECT e.ebuildid, e.version - FROM ebuilds e + SELECT e.ebuildid, e.version, f.moddate + FROM ebuilds e, files f WHERE e.packageid = ? + AND e.ebuildid = f.fileid ORDER BY versioninst desc </sql> <parameters> |