Re: Trunc in Postgres
От | elein |
---|---|
Тема | Re: Trunc in Postgres |
Дата | |
Msg-id | 20030906125504.E18990@cookie обсуждение исходный текст |
Ответ на | Re: Trunc in Postgres (Jeff Eckermann <jeff_eckermann@yahoo.com>) |
Список | pgsql-general |
Try: select '0000000000000000000000041'::integer; Just turn it into a number if you want to truncate the leading zeros. But if you want text output, trim() trim is it. Trim() trims from text fields. select trim( '0' from '00000000000000000000000041'); Also see the replace() function. --elein On Wed, Sep 03, 2003 at 07:44:34AM -0700, Jeff Eckermann wrote: > Look at the "trim" function. > While you are about it, looking over the other > available functions would be worth your while too > (look under "Functions and Operators" in the docs). > > --- Amin Schoeib <aschoeib@4tek.de> wrote: > > > > 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 > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: