lpad question - Mailing list pgsql-general

From Johnson, Shaunn
Subject lpad question
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C740F5@snt452.corp.bcbsm.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: "P.J. \"Josh\" Rovero"
Date:
Subject: locale issues with float
Next
From: Tom Lane
Date:
Subject: Re: number of affected rows in pgtcl