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