[GENERAL] Empty Output? How Do I Determine the Character?

[Hunter Hillegas]

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)

If I then execute:
thedonnaholics=# select count(*) from mailing_list where state = '';
 count 
-------
     0
(1 row)

So, what is in that first row?

This also returns 0:
thedonnaholics=# select count(*) from mailing_list where state = ' ';
 count 
-------
     0
(1 row)

Any ideas? I'd like to select all rows that contain whatever that first one
contains...

Hunter


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster