Re: select statement fails

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