Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group