Re: Empty Output? How Do I Determine the Character? - Mailing list pgsql-general

Hunter Hillegas <lists@lastonepicked.com> writes:
> I cannot determine what character is stored in a varchar...
> For instance:
> thedonnaholics=# select state from mailing_list where rec_num = 7;
>  state
> -------

> (1 row)

I'd say it's either NULL or between one and five space characters.
To find out, try something like

select '>' || state || '<' from mailing_list where rec_num = 7;

            regards, tom lane