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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Optimizer picks an ineffient plan
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Needed function IF(expr, expr, expr)