Re: [UDD] Improved link between LP bug tasks watching Debian bugs and debbugs ids
On Wed, Aug 04, 2010 at 06:29:02PM +0200, Olivier Berger wrote:
> I'd suggest to add a table like :
>
> CREATE TABLE whatever AS
> SELECT bug, int4(substring(watch from 'http://bugs.debian.org/cgi-bin/bugreport\\.cgi\\?bug=(\\d+)')) as debian_bugid
> FROM ubuntu_bugs_tasks WHERE
> watch LIKE 'http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=%';
>
> ...
>
> Any comments ?
Sounds reasonable
Andreas.
--
http://fam-tille.de
Reply to: