05.02.09, 17:16, "Gregory Stark" <st...@enterprisedb.com>:
> "Eduard Deacoon" <d...@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! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
