On Sat, Jun 10, 2006 at 07:15:02PM +0100, Andy Shellam wrote: > So, what I'm trying to do is use a primary key to generate invoice > numbers such as "INV0000001", "INV0000002" etc. Obviously a sequence > generates the increments, but when I try formatting it, it adds a space > at the beginning of the number.
The FM modifier suppresses padding spaces. http://www.postgresql.org/docs/8.1/interactive/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIMEMOD-TABLE test=> SELECT 'INV' || to_char(123, 'FM0000000'); ?column? ------------ INV0000123 (1 row) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
