Results with leading zero

From: novice <user(dot)postgresql(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Results with leading zero
Date: 2008-06-16 01:48:01
Message-ID: ddcb1c340806151848g3f177a06sfb5bf0f88c9adde@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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
need the leading zero for solution < 10

problem_id | solution
-------------+------------
1001 | 01
1001 | 02
1001 | 02
1001 | 04
1012 | 01
1012 | 02
1012 | 03
1012 | 04
1012 | 05
1012 | 06
1012 | 07
1012 | 08
1012 | 09
1012 | 10
1012 | 11
(15 rows)

Thanks.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Guenzel 2008-06-16 05:19:30 Re: Results with leading zero
Previous Message Andreas 2008-06-13 16:02:45 How to manage category-ids as array-fields ?