select statement fails - Mailing list pgsql-general

From Andrus
Subject select statement fails
Date
Msg-id ftgepa$dcb$1@news.hub.org
Whole thread Raw
Responses Re: select statement fails  (Richard Huxton <dev@archonet.com>)
Re: select statement fails  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
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;


Using

"PostgreSQL 8.3beta4, compiled by Visual C++ build 1400"



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: wrong query result
Next
From: Kev
Date:
Subject: Re: plperlu and perl 5.10