SEO

#1 (**permalink**) 04-08-2008, 07:47 PM

Is there any reason why :

SELECT char_length(to_char(1, '000'));

Gives a result

char_length
-------------
4
(1 row)

It seems that to_char(1, '000') gives a string " 001" with a space in front.
Is this a bug?

Regards,

Ben

#2 (**permalink**) 04-08-2008, 07:49 PM

Ben Trewern wrote:
> Is there any reason why :
>
> SELECT char_length(to_char(1, '000'));
>
> Gives a result
>
> char_length
> -------------
> 4
> (1 row)
>
> It seems that to_char(1, '000') gives a string " 001" with a space in front.
> Is this a bug?
>
> Regards,
>
> Ben
>
Try formatting the result:
SELECT char_length(to_char(1, 'fm000'));

char_length
-------------
3

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#3 (**permalink**) 04-08-2008, 07:50 PM

"Ben Trewern" <bendottrewern@mowlem.com> writes:
> It seems that to_char(1, '000') gives a string " 001" with a space in front.
> Is this a bug?

No.

Possibly you want 'FM000'.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

#4 (**permalink**) 04-08-2008, 07:50 PM

From the docs:

"FM suppresses leading zeroes and trailing blanks that would otherwise be
added to make the output of a pattern be fixed-width"

It works now but for one I don't understand why the space is added in the
firs place and two I think the docs don't tell the whole story ie leading
blanks and I assume trailing zeros if applicable.

Regards,

Ben

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:794.1109627049@sss.pgh.pa.us...
> "Ben Trewern" <bendottrewern@mowlem.com> writes:
>> It seems that to_char(1, '000') gives a string " 001" with a space in
>> front.
>> Is this a bug?
>
> No.
>
> Possibly you want 'FM000'.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

#5 (**permalink**) 04-08-2008, 07:52 PM

If the number is negative there needs to be room for the minus sign...

On Tue, Mar 01, 2005 at 09:25:02AM -0000, Ben Trewern wrote:
> >From the docs:
>
> "FM suppresses leading zeroes and trailing blanks that would otherwise be
> added to make the output of a pattern be fixed-width"
>
> It works now but for one I don't understand why the space is added in the
> firs place and two I think the docs don't tell the whole story ie leading
> blanks and I assume trailing zeros if applicable.

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFCJZYsY5Twig3Ge+YRAgvcAJ0WwQNl+fhAUg0+yXe8nv gSO0jP1QCdH+us
n+FTvvhBP/yZR4hkkZAP4Yk=
=7mFO
-----END PGP SIGNATURE-----

#6 (**permalink**) 04-08-2008, 07:52 PM

Thanks, sometimes the obvious just passes me by. :-(

>If the number is negative there needs to be room for the minus sign...

"Martijn van Oosterhout" <kleptog@svana.org> wrote in message
news:20050302103212.GA4567@svana.org...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

to_char bug?