select statement fails

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: select statement fails
Date: 2008-04-08 18:48:56
Message-ID: ftgepa$dcb$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-08 18:51:45 Re: More SSL crash woes
Previous Message Mikko Partio 2008-04-08 18:37:29 Re: "too many trigger records found for relation xyz"