Re: Empty Output? How Do I Determine the Character?

Hunter Hillegas <lists@lastonepicked.com> writes:
> I ran the query you suggested but I don't know what it means:
> thedonnaholics=# select '>' || state || '<' from mailing_list where rec_num
> = 7;
>  ?column?
> ----------

> (1 row)

It means it's NULL.  (Hint: foo = NULL is not the same as foo IS NULL.)

            regards, tom lane