Postgres Pro
Downloads
Home   >   mailing lists

to_char adds leading space, intended? - Mailing list pgsql-sql

From Aasmund Midttun Godal
Subject to_char adds leading space, intended?
Date
Msg-id 20020103043129.20231.qmail@213-145-170-138.dd.nextgentel.com
Whole thread Raw
List pgsql-sql
Tree view 
envisity=# SELECT '''' || to_char(1234, '099999') || '''';                           ?column?  
-----------' 001234'
(1 row)

Is this the way it's meant to be?

I would prefer 
'001234'

So I don't have to ltrim it.
Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Tree structure index usage
Next
From: rolf.ostvik@axxessit.no
Date:
Subject: Re: to_char adds leading space, intended?