ALL in SELECT syntax \h psql flawed?

Started by Alvaro Herreraover 24 years ago4 messagesbugs

alvherre@atentus.com

over 24 years ago

\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)

Thomas Lockhart

lockhart@fourpalms.org

over 24 years ago

In reply to: Alvaro Herrera (#1)

Re: 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 ]

I agree. Bruce ("Mr. Backslash" :) are you planning on picking this up?

- Thomas

bruce@momjian.us

over 24 years ago

In reply to: Alvaro Herrera (#1)

Re: 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)

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

bruce@momjian.us

over 24 years ago

In reply to: Thomas Lockhart (#2)

Re: 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 ]

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