Andrus wrote:
Any idea why the following select statement does not return rows ?
This select statement is generated by npgsql2 beta 3 so I cannot change it
in my application.
How to fix without changing select statement ?
Andrus.
create temp table test ( tc char(1) );
insert into test values(' ');
select * from test where tc=' '::text;
It doesn't return rows because you're using a space-padded type (char)
to try and store a space.
I think you probably want varchar(1) instead.
--
Richard Huxton
Archonet Ltd
