Ok... I don't think that it is null:
thedonnaholics=# select count(*) from mailing_list where state = null;
count
-------
0
(1 row)
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)
Any insight appreciated.
Thanks,
Hunter
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Fri, 08 Aug 2003 19:03:24 -0400
> To: Hunter Hillegas <[EMAIL PROTECTED]>
> Cc: PostgreSQL <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Empty Output? How Do I Determine the Character?
>
> Hunter Hillegas <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
