A Dimecres 19 Març 2008, Nikolay Samokhvalov va escriure:
> 2. Why the query above provides 4 rows, not 2*4=8? Actually, that's
> interesting -- I can use this query to find l.c.m. But it's defenetely
> not that I'd expect before my try...
2*4 = 8:
select * from generate_series(1, 2) a, generate_series(1, 4) b;
Can't tell you about the expected behaviour in the query you provided though.
--
Albert Cervera i Areny
http://www.NaN-tic.com