Re: [GENERAL] to_char bug?

2005-03-04 Thread Ben Trewern


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:[EMAIL PROTECTED] 



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [GENERAL] to_char bug?

2005-03-02 Thread Martijn van Oosterhout
If the number is negative there needs to be room for the minus sign...

On Tue, Mar 01, 2005 at 09:25:02AM -, 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.


pgp5cFrqsC8HC.pgp
Description: PGP signature


Re: [GENERAL] to_char bug?

2005-03-01 Thread Ben Trewern
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 [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Ben Trewern [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
 



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[GENERAL] to_char bug?

2005-02-28 Thread Ben Trewern
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 



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [GENERAL] to_char bug?

2005-02-28 Thread Bricklen Anderson
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


Re: [GENERAL] to_char bug?

2005-02-28 Thread Tom Lane
Ben Trewern [EMAIL PROTECTED] 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 [EMAIL PROTECTED]