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.

- Thomas

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

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"