substring wrong example in manual - Mailing list pgsql-general

From Thomas T. Thai
Subject substring wrong example in manual
Date
Msg-id Pine.NEB.4.21.0107021852090.4601-100000@ns01.minnesota.com
Whole thread Raw
Responses Re: substring wrong example in manual  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
RE: http://www.postgresql.org/idocs/index.php?functions-string.html

In Table 4-6. SQL String Functions and Operators


FUNCTION                RETURN TYPE              DESC
...
substring(              text                     extract
  string                                         substring
  [from integer]
  [for integer])

                        EXAMPLE                  RESULT
                        substring('Thomas'       oma
                        from 2 for 3)
...

The result should be 'hom' instead of 'oma':

       1   2   3   4   5   6
       T   h   o   m   a   s
from   1   2
           ^-------^
for        1   2   3


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: on indexing.
Next
From: Bruce Momjian
Date:
Subject: Re: substring wrong example in manual