Hi!
On Tue, 9 Mar 1999, Hannu Krosing wrote:
> > SELECT cn.date_i, cn.pos_id
> > FROM central cn
> > WHERE cn.date_i >= current_date - '300 days'::timespan
> >
> > returns 3156 rows. But this:
> >
> > SELECT cn.date_i, p.subsec_id, cn.pos_id, p.pos_id
> > FROM central cn, shops sh, districts d, positions p
> > WHERE cn.date_i >= current_date - '300 days'::timespan
>
> this should return
> 3156 * count(shops) * count(districts) * count(positions)
>
> which is probably too much for the backend ;(
Bad news. Thanks for pointing this.
> -----------------------
> Hannu
>
Oleg.
---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they
justGOSUB without RETURN.