Multiple SRF right after SELECT
От | Nikolay Samokhvalov |
---|---|
Тема | Multiple SRF right after SELECT |
Дата | |
Msg-id | e431ff4c0803190503m49eeef76pb91a692009a30331@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Multiple SRF right after SELECT
Re: Multiple SRF right after SELECT Re: Multiple SRF right after SELECT |
Список | pgsql-hackers |
Hi, I wonder, if the following is correct and provides expected result: test=# select generate_series(1, 2), generate_series(1, 4);generate_series | generate_series -----------------+----------------- 1 | 1 2 | 2 1 | 3 2 | 4 (4 rows) Actually I have two questions on this:1. Is it correct at all to use SRF in select list, w/o explicit FROM? Why then we do not allow using subselects that return multiple rows? I'd rather expect that these two things work in similar manner.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... -- Best regards, Nikolay
В списке pgsql-hackers по дате отправления: