Trunc in Postgres - Mailing list pgsql-general

From Amin Schoeib
Subject Trunc in Postgres
Date
Msg-id 70DD6153277512439CA4B66956A3098132D07F@pdc.4tek-net.4tek.de
Whole thread Raw
Responses Re: Trunc in Postgres  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Re: Trunc in Postgres  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: Trunc in Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

Hi,
Is there an equivalent for the trunc function of Oracle in Postgres???
I need to trunc(the zeros) a number which is stored as a char with a lot of zeros
Like that : 0000000000000000000000000000004

In oracle you can make that by trunc(YOUR_COLUMNNAME,0)

Thanxx

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel.  +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: What is the good equivalent for ENUM ?
Next
From: Oliver Elphick
Date:
Subject: Re: Using oids