Re: How to join function with a table?

Поиск
Список
Период
Сортировка
От Yudie Pg
Тема Re: How to join function with a table?
Дата
Msg-id e460d0c050805150677426e0d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to join function with a table?  (Ragnar Hafstað <gnari@simnet.is>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Clog/Transaction problems
Следующее
От: snacktime
Дата:
Сообщение: changing default lockfile location