--howdy:
--okay, i *think* i'm close, but i'm not sure about what
--i'm seeing as results.
--i have this:
[snip]
testdb=> select lpad(to_char(i_pd,'99999D99'),10,'0') as i_pd from t_table limit 1;
[/snip]
and the results are:
[snip results]
i_pd
------------
0 .00
(1 row)
[/snip results]
* Why is there a gap between the lead zero and the decimals?
* Where is the docs to tell me what, exactly, this is doing?
Thanks!
-X
Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
I'm trying to create a view where I lpad a numeric field with leading
zeros and keep the two digits right of the decimal. Can someone send an example?
Thanks!
-X