On Thu, 2011-02-03 at 10:10 -0800, Rich Shepard wrote:
> jerrittwq=# select * from monitor where location = 'GW-24';
> jerrittwq=# select distinct location from monitor;
> location
> ------------------
> <snip>
> 'OMW-9'
> 'GW-24'
> 'FC-2'
>
Is it possible that the values themselves have the quotation marks?
Maybe try:
select * from monitor where location = '''GW-24''';
Or perhaps there is some kind of whitespace or something.
Regards,
Jeff Davis