Thread: unexpected results

unexpected results

From
mixo
Date:
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
as I recently upgraded to 7.2.1, and since then "pg" has not started at
boot time-- I
have to manually start it; and on another version (older) the same query
yields
results. Should I be worried? Or is there some reasonable explanation
for this?


Re: unexpected results

From
Tom Jenkins
Date:
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



Re: unexpected results

From
mixo
Date:
coln is 'text'.

Tom Jenkins wrote:

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