hi.
select * from pg_input_error_info('42000000000', 'integer')
select message, detail from pg_input_error_info('1234.567', 'numeric(7,4)')
I found above two examples at [0] crammed together.
<para>
<literal>select * from pg_input_error_info('42000000000',
'integer')</literal>
<returnvalue></returnvalue>
<programlisting>
message | detail | hint
| sql_error_code
------------------------------------------------------+--------+------+----------------
value "42000000000" is out of range for type integer | | | 22003
</programlisting>
</para>
<para>
<literal>select message, detail from
pg_input_error_info('1234.567', 'numeric(7,4)')</literal>
<returnvalue></returnvalue>
<programlisting>
message | detail
------------------------+----------------------------------&zwsp;-------------------------------------------------
numeric field overflow | A field with precision 7, scale 4 must round
to an absolute value less than 10^3.
</programlisting>
after checking the definition of <programlisting>[1], <screen>[2],
maybe here we should use <screen> and also add `(1 row)` information.
or we can simply add a empty new line between
` value "42000000000" is out of range for type integer | | | 22003`
and
`</programlisting>`
[0]
https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-VALIDITY
[1] https://tdg.docbook.org/tdg/4.5/programlisting
[2] https://tdg.docbook.org/tdg/4.5/screen
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
