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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to