Skip to main content

Questions tagged [postgresql-8.2]

Specifically for PostgreSQL version 8.2

Filter by
Sorted by
Tagged with
1 vote
2 answers
954 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 ...
DataGwynn's user avatar
2 votes
1 answer
816 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 ...
Ela's user avatar
  • 500