Re: Trunc in Postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Amin Schoeib" <aschoeib(at)4tek(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trunc in Postgres
Date: 2003-09-03 14:32:17
Message-ID: 13902.1062599537@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Amin Schoeib" <aschoeib(at)4tek(dot)de> writes:
> 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)

We use the SQL-standard spelling, TRIM().

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2003-09-03 14:36:23 Re: Commercial postgresql
Previous Message Tom Lane 2003-09-03 14:28:59 Re: Recursive Selects