Results with leading zero
От | novice |
---|---|
Тема | Results with leading zero |
Дата | |
Msg-id | ddcb1c340806151848g3f177a06sfb5bf0f88c9adde@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Results with leading zero
Re: Results with leading zero Re: Results with leading zero |
Список | 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.
В списке pgsql-sql по дате отправления: