pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: Bruce Momjian <pgman@candle.pha.pa.us>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: where'd the spaces come from
Date: Thu, 2 Aug 2001 16:56:26 +0100
Message-ID: <01080216562606.18757@gary.ringways.co.uk> (raw)
In-Reply-To: <200108021550.f72FoW727322@candle.pha.pa.us>
References: <200108021550.f72FoW727322@candle.pha.pa.us>

Hi Bruce,

a fix for what? 
If you're meaning the leading space, then the fix is in the followup post 
that I made to my original quiestion. i.e.

psql -c "select to_char(12,'xFM000');"
 to_char
---------
 x012
(1 row)

The 'FM' removes the space.

Gary

On Thursday 02 August 2001  4:50 pm, Bruce Momjian wrote:
> Does anyone have a fix for this?
>
> > From: "Gary Stainburn" <gary.stainburn@ringways.co.uk>
> >
> > > psql -c "select t.tregion || '/' || to_char(t.tnumber,'000') || '-' ||
> > > to_char(m.mnumber,'00') as unitno from teams t, members m
> > > where m.mteam = t.tid;"
> > >    unitno
> > > -------------
> > >  SW/ 041- 03
> > >  SW/ 041- 05
> >
> > Looks like a buglet in to_char()s handling of numbers (unless I
> > misunderstand the way the formatting is supposed to work).
> >
> > select '[' || to_char(12,'x000') || ']';
> >  ?column?
> > ----------
> >  [x 012]
> >
> > If you're running the current version, might be worth posting a bug
> > report. You can work around it with something like:
> >
> > ... substr(to_char(t.tnumber,'000'),2,3) ...
> >
> > HTH
> >
> > - Richard Huxton
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster

-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     



view thread (7+ messages)  latest in thread

Message-ID: <01080216562606.18757@gary.ringways.co.uk>
Permalink:  ../01080216562606.18757@gary.ringways.co.uk/
Also on:    postgresql.org/message-id/01080216562606.18757@gary.ringways.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: gary.stainburn@ringways.co.uk, pgman@candle.pha.pa.us, dev@archonet.com
  Subject: Re: where'd the spaces come from
  In-Reply-To: <01080216562606.18757@gary.ringways.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox