Function name "text_out" should be "textout"
Erwin Brandstetter <brsaweda@gmail.com>
From: Erwin Brandstetter <brsaweda@gmail.com>
To: pgsql-docs@lists.postgresql.org
Date: 2020-07-04T07:59:22Z
Lists: pgsql-docs
Close to the bottom of:
https://www.postgresql.org/docs/devel/plpgsql-implementation.html
(and all previous version)
... the manual says:
> During the ensuing assignment to the local variable curtime, the PL/pgSQL
interpreter casts this string to the timestamp type by calling the text_out
and timestamp_in functions for the conversion.
Should most probably be "textout" instead of "text_out". See:
test=# SELECT proname FROM pg_proc
WHERE proname IN ('text_out', 'textout');
proname
---------
textout
(1 row)
"timestamp_in" seems correct, though. Those function names seem rather
inconsistent: roughly half of them have the underscore, the rest doesn't.
Might explain the confusion.
SELECT * FROM pg_proc
WHERE proname ~ 'out$'
AND prorettype = 'cstring'::regtype
ORDER BY proname ~ '_out$';
SELECT * FROM pg_proc
WHERE proname ~ 'in$'
AND proargtypes = ARRAY['cstring'::regtype]::oidvector
ORDER BY proname ~ '_in$';
Regards
Erwin
Commits
-
doc: Fix incorrect reference to textout in plpgsql examples
- e3ed833e0c56 9.5.23 landed
- 2d7738a83cae 9.6.19 landed
- 49d7d5f21f9d 10.14 landed
- d51155544bef 11.9 landed
- 939db2c1c858 12.4 landed
- 45f165b18b72 13.0 landed
- 8cea55e99b76 14.0 landed