Horton
Menu

Re: How to properly use TRIM()?

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: Rob Sargent <robjsargent@gmail.com>, Adrian Klaver <adrian.klaver@aklaver.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-03-07T20:03:19Z
Lists: pgsql-general 
On Sat, Mar 7, 2026 at 12:58 PM Igor Korot <ikorot01@gmail.com> wrote:

> So I started looking for a way to return SQL_NO_DATA
> on that 4th column...
>

Doesn't "No Data" refer to the result set as a whole, not individual
columns?  I'd assume NULL is detected some other way.

David J.