Re: BUG #4640: Drop leading zero in EXECUTE

From: Дикун Эдуард <deac(at)yandex(dot)ru>
To: "Gregory Stark"<stark(at)enterprisedb(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4640: Drop leading zero in EXECUTE
Date: 2009-02-05 14:22:26
Message-ID: 27951233843746@webmail55.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

05.02.09, 17:16, "Gregory Stark" <stark(at)enterprisedb(dot)com>:

> "Eduard Deacoon" <deac(at)yandex(dot)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!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2009-02-05 15:26:04 Re: BUG #4516: FOUND variable does not work after RETURN QUERY
Previous Message Gregory Stark 2009-02-05 14:16:21 Re: BUG #4640: Drop leading zero in EXECUTE