>
> what about something like
>
> select id,datelist
> from payment as p,
> (select * from datelist('8/1/2005, 8/5/2005')) as list
> where datelist between p.date_start and p.date_end;
That's works but have to put the whole date range into the parameters before
it can be joined.
This would need 2 queries where the first query only to find minumum &
maximum date that possibly recorded on payment table.