Re: How to join function with a table?

From: Pascual De Ruvo <deruvo(at)gmail(dot)com>
To: Yudie Pg <yudiepg(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to join function with a table?
Date: 2005-08-05 20:06:17
Message-ID: fb73c1ee05080513067a911e7b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/5/05, Yudie Pg <yudiepg(at)gmail(dot)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.....

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Logan Bowers 2005-08-05 20:52:29 Clog/Transaction problems
Previous Message Thomas Pundt 2005-08-05 19:06:22 Re: DNS vs /etc/hosts