Обсуждение: error on „ 38.5. Query Language (SQL) Functions“: a single row is returned
error on „ 38.5. Query Language (SQL) Functions“: a single row is returned
От
PG Doc comments form
Дата:
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.
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