pgsql: plpgsql: Clarify the LIMIT 1 example in the too-many-rows hint
pgsql: plpgsql: Clarify the LIMIT 1 example in the too-many-rows hint
От:
Fujii Masao <fujii@postgresql.org>
Дата:
plpgsql: Clarify the LIMIT 1 example in the too-many-rows hint The hint for queries returning more than one row suggested using LIMIT 1, but it was also shown for commands such as UPDATE ... RETURNING, which do not support that clause. Reword the hint to use LIMIT 1 with SELECT as an example, retaining concrete advice for SELECT queries without suggesting that LIMIT 1 can be used with every command. Author: Jeevan Chalke Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAHGQGwH2xDa7CqHkKZfiWQ9+waBdUm8Vh6Br2XNMAiG3vi-hQQ@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/60cdae088b6d86e38059c32a0a1fd66e46de2389 Modified Files -------------- src/pl/plpgsql/src/pl_exec.c | 2 +- src/test/regress/expected/plpgsql.out | 16 ++++++++-------- 2 files changed, 9 insertions(+), 9 deletions(-)