Re: [BUGS] multiple SRFs in SELECT clause.

2006-11-27 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > I'm getting some odd results when running two generate_series calls in a > SELECT ... > When the row counts differ you get the least common multiple number of > rows. Yup, this is the expected or at least historical behavior. It's not entirely clear what

[BUGS] multiple SRFs in SELECT clause.

2006-11-27 Thread Kris Jurka
I'm getting some odd results when running two generate_series calls in a SELECT. When the two calls return the same number of rows you get that many rows out: # SELECT generate_series(1,3), generate_series(1,3); generate_series | generate_series -+-