From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: david.g.johnston@gmail.com
Subject: SETOF specification and default behavior (CREATE FUNCTION)
Date: Mon, 28 Jun 2021 15:37:15 +0000
Message-ID: <162489463589.697.11530554063646944264@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createfunction.html
Description:
It seems like an oversight that the synopsis for CREATE FUNCTION doesn't
actually show the modifier "SETOF" as a optional literal part of the syntax
but only describes it as a modifier to the data type identifier in the
"rettype" description.
Additionally, its unclear whether there is any other way to specify that a
function returns a set other than using RETURNS SETOF (which is otherwise an
optional clause since you can use OUT arguments instead).
Putting the two together, it is unclear whether writing only "RETURNS SETOF"
is allowed when using OUT arguments. I'm pretty sure it is not due to the
"its a modifier" clause in the description.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, david.g.johnston@gmail.com
Subject: Re: SETOF specification and default behavior (CREATE FUNCTION)
In-Reply-To: <162489463589.697.11530554063646944264@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox