Skip site navigation (1) Skip section navigation (2)

Re: Results with leading zero

From: novice <user(dot)postgresql(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Results with leading zero
Date: 2008-06-16 06:48:04
Message-ID: ddcb1c340806152348i10ae327m867a0c9f03e40c1b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
Perfect!
Thank you very mcuh :)

2008/6/16 A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>:
> 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
>> need the leading zero for solution < 10
>>
>>  problem_id | solution
>> -------------+------------
>>         1001 | 01
>>         1001 | 02
>
> My previous answer was a little bit wrong (no leading zero for solution
> < 10), sorry. But no problem:
>
> select problem_id, to_char(generate_Series(1,solution_count),'09') as solution_count from problem ;
>
>
>
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>



-- 
THINK BEFORE YOU PRINT - Save paper if you don't really need to print this.

In response to

Responses

pgsql-sql by date

Next:From: Tena SakaiDate: 2008-06-16 16:35:01
Subject: Re: Results with leading zero
Previous:From: A. KretschmerDate: 2008-06-16 06:21:45
Subject: Re: Results with leading zero

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group