Home > mailing lists

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

From	Pascual De Ruvo
Subject	Re: How to join function with a table?
Date	August 5, 2005 20:06:37
Msg-id	fb73c1ee05080513067a911e7b@mail.gmail.com Whole thread Raw
In response to	How to join function with a table? (Yudie Pg <yudiepg@gmail.com>)
Responses	Re: How to join function with a table? (Yudie Pg <yudiepg@gmail.com>)
List	pgsql-general

On 8/5/05, Yudie Pg <yudiepg@gmail.com> wrote:

I thought simple join like this would work, but it doesn't
select * from payment P, datelist(P.date_start , P.date_end)

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

From: Thomas Pundt
Date: 05 August 2005, 19:06:30
Subject: Re: DNS vs /etc/hosts

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