> -----Original Message-----
> From: Daniel Kalchev
>
> I tried this:
>
> db=# select * into iplog_test from iplog_gate200112;
> SELECT
> db=# create index iplog_test_ipaddr_idx on iplog_test(ipaddr);
> CREATE
> db=# cluster iplog_test_ipaddr_idx on iplog_test;
> CLUSTER
> db=# create index iplog_test_ipdate_idx on iplog_test(ipdate);
> CREATE
> db=# explain
> db-# SELECT sum(input), sum(output) FROM iplog_test
> db-# WHERE
> db-# '2001-12-01 00:00:00+02' <= ipdate AND ipdate < '2001-12-02
> 00:00:00+02'
Is there only one ipdate value which satisfies the above where clause ?
regards,
Hiroshi Inoue