Sender: Daniel Gustafson <daniel.gustafson@gmail.com>
From: Daniel Gustafsson <daniel@yesql.se>
Content-Type: multipart/mixed;
 boundary="Apple-Mail=_657A7227-6A91-4BD2-A47B-AFF1790FC7C3"
Subject: PARALLEL in old syntax for CREATE AGGREGATE
Message-Id: <8400AFAE-4625-4F58-9A7A-0EF8BF2C9189@yesql.se>
Date: Mon, 27 Nov 2017 16:00:42 +0100
To: pgsql-docs <pgsql-docs@postgresql.org>
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Precedence: bulk


--Apple-Mail=_657A7227-6A91-4BD2-A47B-AFF1790FC7C3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

When looking at review comments on one of my patches, I noticed that =
commit
41ea0c23761 didn=E2=80=99t include the PARALLEL keyword for the old =
style CREATE
AGGREGATE syntax.  Since it is supported, and commit 59b71c6fe6c use it =
in a
testcase, it seems reasonable to add something along the lines of the =
attached
patch to the docs.

cheers ./daniel


--Apple-Mail=_657A7227-6A91-4BD2-A47B-AFF1790FC7C3
Content-Disposition: attachment;
	filename=create_agg_parallel.patch
Content-Type: application/octet-stream;
	name="create_agg_parallel.patch"
Content-Transfer-Encoding: quoted-printable

=46rom=202ed82ee3f3fa28bd69f2981730cf60d89c8f3867=20Mon=20Sep=2017=20=
00:00:00=202001=0AFrom:=20Daniel=20Gustafsson=20<daniel@yesql.se>=0A=
Date:=20Mon,=2027=20Nov=202017=2015:29:15=20+0100=0ASubject:=20[PATCH=20=
2/2]=20doc:=20add=20PARALLEL=20option=20to=20old=20syntax=20for=20CREATE=0A=
=20AGGREGATE=0A=0AThe=20old=20pre-8.2=20syntax=20for=20CREATE=20=
AGGREGATE=20also=20support=20PARALLEL,=0Aeven=20though=20it's=20required=20=
to=20be=20quoted=20as=20PARALLEL=20is=20an=20unreserved=0Akeyword.=0A---=0A=
=20doc/src/sgml/ref/create_aggregate.sgml=20|=205=20+++++=0A=201=20file=20=
changed,=205=20insertions(+)=0A=0Adiff=20--git=20=
a/doc/src/sgml/ref/create_aggregate.sgml=20=
b/doc/src/sgml/ref/create_aggregate.sgml=0Aindex=20=
a4aaae876e..d813ec41e6=20100644=0A---=20=
a/doc/src/sgml/ref/create_aggregate.sgml=0A+++=20=
b/doc/src/sgml/ref/create_aggregate.sgml=0A@@=20-80,6=20+80,7=20@@=20=
CREATE=20AGGREGATE=20<replaceable=20class=3D"parameter">name</replaceable>=
=20(=0A=20=20=20=20=20[=20,=20MFINALFUNC_MODIFY=20=3D=20{=20READ_ONLY=20=
|=20SHARABLE=20|=20READ_WRITE=20}=20]=0A=20=20=20=20=20[=20,=20MINITCOND=20=
=3D=20<replaceable=20class=3D"parameter">minitial_condition</replaceable>=20=
]=0A=20=20=20=20=20[=20,=20SORTOP=20=3D=20<replaceable=20=
class=3D"parameter">sort_operator</replaceable>=20]=0A+=20=20=20=20[=20,=20=
"PARALLEL"=20=3D=20{=20SAFE=20|=20RESTRICTED=20|=20UNSAFE=20}=20]=0A=20)=0A=
=20</synopsis>=0A=20=20</refsynopsisdiv>=0A@@=20-630,6=20+631,10=20@@=20=
SELECT=20col=20FROM=20tab=20ORDER=20BY=20col=20USING=20sortop=20LIMIT=20=
1;=0A=20=20=20=20=20=20=20functions=20are=20not=20consulted=20by=20the=20=
planner,=20only=20the=20marking=20of=20the=0A=20=20=20=20=20=20=20=
aggregate=20itself.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A=
+=20=20=20=20=20=20=20Note=20that=20when=20using=20the=20old=20syntax,=20=
<literal>"PARALLEL"</literal>=20must=0A+=20=20=20=20=20=20=20be=20=
quoted.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=
=20</varlistentry>=0A=20=0A--=20=0A2.14.1.145.gb3622a4ee=0A=0A=

--Apple-Mail=_657A7227-6A91-4BD2-A47B-AFF1790FC7C3
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=us-ascii


--Apple-Mail=_657A7227-6A91-4BD2-A47B-AFF1790FC7C3--