ALL in SELECT syntax \h psql flawed?
\h select in psql says (among other things)
[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
I think it should read
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
(the SQL reference says the same thing as psql)
--
Alvaro Herrera (<alvherre[@]atentus.com>)
"La virtud es el justo medio entre dos defectos" (Aristoteles)
\h select in psql says (among other things)
[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
I think it should read
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
I agree. Bruce ("Mr. Backslash" :) are you planning on picking this up?
- Thomas
\h select in psql says (among other things)
[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
I think it should read
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
(the SQL reference says the same thing as psql)
Good catch! Hard to imagine how we missed seeing this mistake. Patch
applied.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Attachments:
/bjm/difftext/plainDownload+6-6
\h select in psql says (among other things)
[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
I think it should read
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]I agree. Bruce ("Mr. Backslash" :) are you planning on picking this up?
Done. :-)
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026