On Thursday, February 20, 2025, Susmitha S <susmithaselvarani(dot)ds(at)gmail(dot)com>
wrote:
>
>
> 1.
> - However, when the ERROR ON ERROR clause is omitted, instead of
> throwing an error or returning a meaningful response, it simply returns an *empty
> result*.
>
> [image: image.png]
>
>
The meaning of “empty result” in PostgreSQL is a result set with zero
rows. As shown here you get a result/rows, their contents are just null
(consider using \pset null ‘<null>’ or some such if you want to distinguish
empty string from nulls).
As already mentioned, the production of a null value for non-matches is the
documented behavior.
David J.