Questions tagged [postgresql-8.2]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
64 views

Find members with consecutive entries

I need to find all members in the database with data on 7 or more consecutive days. The table is set up as member_id and data_date. There are duplicate member_ids for each day that there is data. I ...
3
votes
1answer
622 views

How to count selectivity rows in PostgreSQL 8.2

I have problem with two queries on PostgreSQL v8.2. It seem like the optimizer chooses a wrong index: db=# explain select count(*), messagetype, alias from event where templateinfoid = 10 and ...