Anybody a solution for the next problem: people can subscribe to a service for 1 or more days (upto a max. of 365).
So in the database is stored: first_date and last_date To select which people are subscribed for a certain date (e.g. today) we use a select like select ....... where first_date <= today and last_date >= today Whatever index we create system always does a sequential scan (which I can understand). Has someone a smarter solution? All suggestions will be welcomed. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]