Re: Results with leading zero

am  Mon, dem 16.06.2008, um 11:48:01 +1000 mailte novice folgendes:
> I have a table
> 
> CREATE TABLE problem (
>   problem_id  integer,
>   solution_count integer
>   );
> 
> INSERT INTO problem VALUES (1001, 4);
> INSERT INTO problem VALUES (1012, 11);
> 
> SELECT * from problem;
> 
>  problem_id | solution_count
> ------------+---------------
>        1001 |             4
>        1012 |            11
> (2 rows)
> 
> 
> Is there a way I could write a query to produce the following?  I will


Sure:
 select problem_id, generate_Series(1,solution_count) as solution_count
from problem ;


Regards, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql