Your solution works in this example, but when I take a columnname which type is char(30) I beome the following error:
ERROR: Cannot cast type character to integer -----Ursprüngliche Nachricht----- Von: Pavel Stehule [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 3. September 2003 15:56 An: Amin Schoeib Cc: [EMAIL PROTECTED] Betreff: Re: [GENERAL] Trunc in Postgres You can try select CAST(cast('0000000000000000000000004' as NUMERIC(20)) AS varchar); Pavel > > 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 > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])