Re: Multiple SRF right after SELECT

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