multiple SRFs in SELECT clause.
| От | Kris Jurka |
|---|---|
| Тема | multiple SRFs in SELECT clause. |
| Дата | |
| Msg-id | Pine.BSO.4.64.0611270549540.13818@leary2.csoft.net обсуждение исходный текст |
| Ответы |
Re: multiple SRFs in SELECT clause.
|
| Список | pgsql-bugs |
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
-----------------+-----------------
1 | 1
2 | 2
3 | 3
(3 rows)
When the row counts differ you get the least common multiple number of
rows.
# SELECT generate_series(1,4), generate_series(1,2);
generate_series | generate_series
-----------------+-----------------
1 | 1
2 | 2
3 | 1
4 | 2
(4 rows)
I was personally expecting a cross join between them that would be
equivalent to
# SELECT * FROM generate_series(1,4) a, generate_series(1,2) b;
a | b
---+---
1 | 1
1 | 2
2 | 1
2 | 2
3 | 1
3 | 2
4 | 1
4 | 2
(8 rows)
Tested on 8.1.3 and CVS HEAD.
Kris Jurka
В списке pgsql-bugs по дате отправления: