| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | ganguly(dot)04(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17450: SUBSTRING function extracting lesser characters than specified |
| Date: | 2022-03-28 11:01:20 |
| Message-ID: | 20220328110119.GA28018@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Mar 28, 2022 at 10:30:07AM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17450
> Logged by: Suman Ganguly
> Email address: ganguly(dot)04(at)gmail(dot)com
> PostgreSQL version: 10.17
> Operating system: x86_64-pc-linux-gnu
> Description:
>
> select substring('123456', 0 , 5)
> On running this, Postgres returns '1234'
> Expecting '12345' to be returned as per the documentation
Well, the problem is that you're trying to provide character number 0,
which is leading to bad results.
substring works on base-1 numbering.
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Borisov | 2022-03-28 12:35:30 | Re: BUG #17450: SUBSTRING function extracting lesser characters than specified |
| Previous Message | PG Bug reporting form | 2022-03-28 10:30:07 | BUG #17450: SUBSTRING function extracting lesser characters than specified |