unexpected results

Поиск
Список
Период
Сортировка
Искать

unexpected results

От:
mixo <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?

Re: unexpected results

От:
Tom Jenkins <tjenkins@devis.com>
Дата:
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

От:
mixo <mixo@beth.uniforum.org.za>
Дата:
coln is 'text'.

Tom Jenkins wrote:

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