Home > mailing lists

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	August 5, 2005 17:58:27
Msg-id	e460d0c05080513586433f64c@mail.gmail.com Whole thread Raw
In response to	Re: How to join function with a table? (Pascual De Ruvo <deruvo@gmail.com>)
List	pgsql-general

try select * from payment as p, (select * from datelist('8/1/2005, 8/5/2005')) as date
where date...... = p.....

The problem is the function's parameters '8/1/2005', '8/5/2005' has to refer to whatever value on the payment records.

From: "Logan Bowers"
Date: 05 August 2005, 17:52:35
Subject: Clog/Transaction problems

From: Ragnar Hafstað
Date: 05 August 2005, 18:33:08
Subject: Re: How to join function with a table?