Re: unexpected results - Mailing list pgsql-general

From Tom Jenkins
Subject Re: unexpected results
Date
Msg-id 1029165255.11652.0.camel@asimov
Whole thread Raw
In response to unexpected results  (mixo <mixo@beth.uniforum.org.za>)
List pgsql-general
On Mon, 2002-08-12 at 08:12, mixo wrote:
> On 7.2.1-5, from this
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> select col1,col2 from table1 where coln = 'somelongstring'
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> I get no results. But if change to a wildcard, then I get results. This
> worries me

What's the schema for table1?
is coln a varchar or a char or a text?

--

Tom Jenkins
Development InfoStructure
http://www.devis.com



pgsql-general by date:

Previous
From: chris.gamble@CPBINC.com
Date:
Subject: Max user connections from Postgres Linux 7.2.1
Next
From: Andrew Sullivan
Date:
Subject: Re: [HACKERS] Linux Largefile Support In Postgresql RPMS