[Charset ISO-8859-1 unsupported, filtering to ASCII...]
>
> 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.
VACUUM ANALYZE the table. 6.5.* should not have this problem.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026