"james" <spare1(at)cqm(dot)co(dot)uk> writes:
> I get the full table back, but when I do a
> psql> SELECT * from tablename WHERE column_name =3D'variable';
> it returns empty rows even though I know for a fact and have checked using =
> the select * query that rows should exist and have the variable in the corr=
> ect column!!!
Corrupted index maybe? If there's an index on column_name, try dropping
and rebuilding it.
regards, tom lane