Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 2DFE9633606
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Tue, 28 Apr 2009 15:34:47 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 98221-10 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Tue, 28 Apr 2009 15:34:39 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28])
	by mail.postgresql.org (Postfix) with ESMTP id 2B8CD632BD9
	for <pgsql-docs@postgresql.org>; Tue, 28 Apr 2009 15:34:42 -0300 (ADT)
Received: by yw-out-2324.google.com with SMTP id 3so427393ywj.73
	for <pgsql-docs@postgresql.org>; Tue, 28 Apr 2009 11:34:41 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=vQ09M9kaegGbFEPN0EbUZLlqmWffP999bzary18p1Ek=;
	b=sigh7NMYq8kHtQFzXkV8tuzF1jHjtl8r3t8xgWRBHir5/DDSQ1RKnJdWQ7XQAxtsCf
	KoZN6InNwnMZ7RsrYyGhRWvYkK1l8vLmXIKeeSfjBJX6qcTrESkKrUlcYTf0UtRS9uci
	A1KfG7EdYiGT4xWjZrQ1QUAmaDWDGYfpkyjvw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=wPLz+guVmys3d4SAvAXIxB4npxgryKhKvB3EY2C8bag1MpZ1Fm/p5h0mLk8EkHEHrr
	irES8fctvOgSEpbD/CgZHE8abQlGaw8vQNi6iec5evQo47C5ep95r9g4JuTYRR+vSyUz
	2VpkM1PYjzQ3juUb3hx31lAAyl0YZK3hd6qJY=
MIME-Version: 1.0
Received: by 10.90.105.17 with SMTP id d17mr8796220agc.68.1240943677537; Tue,
	28 Apr 2009 11:34:37 -0700 (PDT)
Date: Tue, 28 Apr 2009 11:34:37 -0700
Message-ID: <607ccf8a0904281134t5fc27233xa1d3d881bdc24012@mail.gmail.com>
Subject: doc bug: SELECT SUBSTRING example is missing keyword FROM
From: Arley Lewis <arleylewis@gmail.com>
To: PostgreSQL Docs List <pgsql-docs@postgresql.org>
Content-Type: multipart/alternative; boundary=0016e64f4a6818b0060468a1b75d
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.967 tagged_above=0 required=5 tests=AWL=0.966,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200904/72
X-Sequence-Number: 5160

--0016e64f4a6818b0060468a1b75d
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hello doc team,

There's a doc bug on
http://www.postgresql.org/docs/8.3/static/functions-matching.html.

Two "FROM"s are missing from this section. Where it now says:
-------------
SELECT SUBSTRING('XY1234Z', 'Y*([0-9]{1,3})');
Result: 123
SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})');
Result: 1
----------------

You should fix it to say:
-------------------
SELECT SUBSTRING('XY1234Z' FROM 'Y*([0-9]{1,3})');
Result: 123
SELECT SUBSTRING('XY1234Z' FROM 'Y*?([0-9]{1,3})');
Result: 1
----------------------

Thanks,
Arley Lewis
arleylewis@gmail.com

--0016e64f4a6818b0060468a1b75d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello doc team,<br><br>There&#39;s a doc bug on <a href=3D"http://www.postg=
resql.org/docs/8.3/static/functions-matching.html">http://www.postgresql.or=
g/docs/8.3/static/functions-matching.html</a>.<br><br>Two &quot;FROM&quot;s=
 are missing from this section. Where it now says:<br>
-------------<br>SELECT SUBSTRING(&#39;XY1234Z&#39;, &#39;Y*([0-9]{1,3})&#3=
9;);<br>Result: 123<br>SELECT SUBSTRING(&#39;XY1234Z&#39;, &#39;Y*?([0-9]{1=
,3})&#39;);<br>Result: 1<br>----------------<br><br>You should fix it to sa=
y:<br>
-------------------<br>SELECT SUBSTRING(&#39;XY1234Z&#39; FROM &#39;Y*([0-9=
]{1,3})&#39;);<br>Result: 123<br>SELECT SUBSTRING(&#39;XY1234Z&#39; FROM &#=
39;Y*?([0-9]{1,3})&#39;);<br>Result: 1<br>----------------------<br><br>
Thanks,<br>Arley Lewis<br><a href=3D"mailto:arleylewis@gmail.com">arleylewi=
s@gmail.com</a><br><br><br>

--0016e64f4a6818b0060468a1b75d--