Re: How to join function with a table? - Mailing list pgsql-general

From Yudie Pg
Subject Re: How to join function with a table?
Date
Msg-id e460d0c050805150677426e0d@mail.gmail.com
Whole thread Raw
In response to Re: How to join function with a table?  (Ragnar Hafstað <gnari@simnet.is>)
List pgsql-general
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.

 

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Clog/Transaction problems
Next
From: snacktime
Date:
Subject: changing default lockfile location