Re: [HACKERS] INTERSECT/EXCEPT and duplicates?

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> SQL92 seems to assume that results of the INTERSECT/EXCEPT contain no
> duplications unless "ALL" is specified. However PostgreSQL 6.5.1 does
> not follow the requirement, I think.

I think you are right --- the ALL keyword is only implemented for UNION
(and it's not quite right there either :-().  For the other two, you
just get whichever behavior was easiest to implement, I suppose...
        regards, tom lane