Re: Intersection or zero-column queries
| От | Victor Yegorov |
|---|---|
| Тема | Re: Intersection or zero-column queries |
| Дата | |
| Msg-id | CAGnEbohAYxEXt86+Wi84+dOaPZU=bPfk6wNg6zutt3=fntmskg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Intersection or zero-column queries ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Intersection or zero-column queries
|
| Список | pgsql-general |
2017-12-22 2:03 GMT+02:00 David G. Johnston <david.g.johnston@gmail.com>:
postgres=# select except select;--(2 rows)postgres=# select intersect all select;--(2 rows)Why is it so?Should this be reported as a bug?.. ;)The intersection case seems correct - one row from each sub-relation is returned since ALL is specified and both results as the same.
Actually, result will not change with or without `ALL` for both, EXCEPT and INTERSECT.
Also, intersection should not return more rows, than there're in the sub-relations.
Victor Yegorov
В списке pgsql-general по дате отправления: