Thanks for fixing it. I always forget the syntax for substring, so I look in
the online docs, and I don't blink twice because I am accustomed to strings
being 0-based, until I don't get the results I expect. Fortunately I
remembered something was fishy about the example and I tested before
running.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: Bruce Momjian <pgman@candle.pha.pa.us>
> Date: Thu, 25 Oct 2001 23:00:36 -0400 (EDT)
> To: lockhart@fourpalms.org
> Cc: Keary Suska <hierophant@pcisys.net>, Postgres General
> <pgsql-general@postgresql.org>
> Subject: Re: [GENERAL] FYI To Postgres Authors
>
>>> The description of the "substring" function in the 7.1 docs is still wrong:
>>> substring('Thomas' from 2 for 3) -> 'oma'
>>> No, it's 'hom'.
>>
>> Yup. I should have used the database to calculate it, eh? Will be fixed.
>> Thanks.
>
> I see in SGML:
>
> <entry><literal>substring('Thomas' from 2 for 3)</literal></entry>
> <entry><literal>hom</literal></entry>
>
> Looks OK to me, and in the database:
>
> test=> select substring('Thomas' from 2 for 3);
> substring
> -----------
> hom
> (1 row)
>
> My guess is that we fixed it after 7.1.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>