From: Tom Lane <tgl@sss.pgh.pa.us>
To: code@lhorn.de
cc: pgsql-docs@lists.postgresql.org
Subject: Re:
 =?utf-8?q?error_on_=E2=80=9E_38=2E5=2E_Query_Language_=28SQL=29_Functions=E2=80=9C=3A_a_single_row_is_returned?=
In-reply-to: <166349067787.658.11227272900830206613@wrigleys.postgresql.org>
References: <166349067787.658.11227272900830206613@wrigleys.postgresql.org>
Comments: In-reply-to PG Doc comments form <noreply@postgresql.org>
	message dated "Sun, 18 Sep 2022 08:44:37 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <157901.1663513264.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Sun, 18 Sep 2022 11:01:04 -0400
Message-ID: <157902.1663513264@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/157902.1663513264%40sss.pgh.pa.us>
Precedence: bulk

PG Doc comments form <noreply@postgresql.org> writes:
> The following documentation comment has been logged on the website:
> Page: https://www.postgresql.org/docs/14/xfunc-sql.html
> Description:

> On the page „ 38.5. Query Language (SQL) Functions“ below the example

> CREATE FUNCTION new_emp() RETURNS emp AS $$
>     SELECT ROW('None', 1000.0, 25, '(2,2)')::emp;
> $$ LANGUAGE SQL;

> this sentence is wrong:

> „ Here we wrote a SELECT that returns just a single column of the correct
> composite type.“

> It is not a single column but a single row that is returned.

It's also a single column, which is more relevant to the point being
made.  Compare this to the immediately preceding example.

			regards, tom lane