unexpected results

Started by mixoover 23 years ago3 messagesgeneral
Jump to latest
#1mixo
mixo@beth.uniforum.org.za

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?
#2Tom Jenkins
tjenkins@devis.com
In reply to: mixo (#1)
Re: unexpected results

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

#3mixo
mixo@beth.uniforum.org.za
In reply to: mixo (#1)
Re: unexpected results

coln is 'text'.

Tom Jenkins wrote:

Show quoted text

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