lpad question

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: lpad question
Date: 2002-10-25 13:53:19
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C740F5@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I'm trying to create a view where I lpad a numeric field with leading
zeros and keep the two digits right of the decimal. Can someone send an
example?

Thanks!

-X

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-25 13:55:16 Re: number of affected rows in pgtcl
Previous Message P.J. "Josh" Rovero 2002-10-25 13:32:01 locale issues with float