Re: BUG #4640: Drop leading zero in EXECUTE

05.02.09, 17:16, "Gregory Stark" <stark@enterprisedb.com>:

> "Eduard Deacoon" <deac@yandex.ru> writes:
> > If $4 has leading zero it does`n work :(
> please expand on "doesn't work"
> > Context replace with ''0 || '' || $4 work only if $4 have one leading zero.
> > ''00 || '' || $4 does`n work, ''0 || 0 ||'' || $4 - work
> I'm sorry I'm not following this part. What parameters did you call this
> function with? What did you expect to happen? What actually happened?
> --
>   Gregory Stark
>   EnterpriseDB          http://www.enterprisedb.com
>   Ask me about EnterpriseDB's 24x7 Postgres support!

--

When $4 contain '0001' then have '1'
When $4 contain '0000' then have NULL
When string contain digits only with leading zero, then EXECUTE drop leading zero.

Best regards!