Re: [ADMIN] restriction clause selectivity bad value - Mailing list pgsql-sql

From Marcio Macedo
Subject Re: [ADMIN] restriction clause selectivity bad value
Date
Msg-id Pine.LNX.4.20.0001031513030.6043-100000@animaniacs.conectiva.com.br
Whole thread Raw
In response to restriction clause selectivity bad value  ("Wallingford, Ted" <twallingford@indexc.com>)
Responses Re: [ADMIN] restriction clause selectivity bad valueu  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
I got an error like this after use alter table to add a column

when I do a select I got this:


database=> select * from table where column = 1;
ERROR:  RestrictionClauseSelectivity: bad value 2.452260

but if i do :
select * from table where column > 1;
it goes ok.

strange...


On Mon, 3 Jan 2000, Wallingford, Ted wrote:

> Can somebody translate this error to english for me :)
>
> ERROR: RestrictionClauseSelectivity: bad value 2.451276
>
> I'm getting it whenever I try to run an update query through ODBC.. any
> ideas?
>
> Thanks,
>
> Ted Wallingford
>
> ************
>

--
--Marcio Macedo
    Conectiva

"Se você assume que não há esperança,
 você garante que não haverá esperança.
 Se você assume que há um instinto de liberdade,
 há oportunidades para mudar as coisas."

-Noam Chomsky


pgsql-sql by date:

Previous
From: "Wallingford, Ted"
Date:
Subject: restriction clause selectivity bad value
Next
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] restriction clause selectivity bad value