Dear Hannu,
>
> "Robert E. Bruccoleri" wrote:
> >
> > explain select count(*) from comparisons_4 where code = 80003;
> > NOTICE: QUERY PLAN:
> >
> > Aggregate (cost=15659.29..15659.29 rows=1 width=0)
> > -> Seq Scan on comparisons_4 (cost=0.00..15640.81 rows=7391 width=0)
> >
> > EXPLAIN
>
> What is the type of field "code" ?
int4
Do you think that should make a difference?
+----------------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | Phone: 609 737 6383 |
| President, Congenomics, Inc. | Fax: 609 737 7528 |
| 114 W Franklin Ave, Suite K1,4,5 | email: bruc@acm.org |
| P.O. Box 314 | URL: http://www.congen.com/~bruc |
| Pennington, NJ 08534 | |
+----------------------------------+------------------------------------+