Re: [UDD] Suggested table: release_order

[Andreas Tille <andreas@an3as.eu>]

On Wed, Feb 03, 2010 at 04:32:36PM +0100, Andreas Tille wrote:
> 
> CREATE TABLE releases (
>        release     text,  /* keep name column as in other tables */
>        releasedate date,
>        sort        int,
>        PRIMARY KEY (releasename)
> );
> 
> INSERT INTO releases VALUES ( 'etch',                     '2007-04-08', 400 );
> INSERT INTO releases VALUES ( 'etch-security',            '2007-04-09', 401 ); /* date or NULL ?? */
> INSERT INTO releases VALUES ( 'etch-proposed-updates',    '2007-04-10', 402 ); /* date or NULL ?? */

... or rather using the same date for 'etch%' and 'lenny%' because the
ordering is done by sort.

Kind regards

       Andreas. 

-- 
http://fam-tille.de