Re: Results with leading zero

Hi,

Not to say which is better or worse, I find the use
of lpad() interesting as well:

select problem_id,
lpad (cast(solution_count as varchar), 9, '0')
from problem;

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org on behalf of novice
Sent: Sun 6/15/2008 11:48 PM
To: A. Kretschmer
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Results with leading zero

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.