substring wrong example in manual

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: substring wrong example in manual
Date: 2001-07-03 00:05:47
Message-ID: Pine.NEB.4.21.0107021852090.4601-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-07-03 02:41:48 Re: substring wrong example in manual
Previous Message Martijn van Oosterhout 2001-07-02 23:55:10 Re: on indexing.