search

AlisdairO / pgexercises

PostgreSQL Exercises web site code
Other
400 stars 62 forks source link

Unique exercise has wrong result #36

Closed cdxf closed 6 years ago

cdxf commented 6 years ago

https://www.pgexercises.com/questions/basic/unique.html Here is the expected result:

surname
--
Bader
Baker
Boothe
Butters
Coplin
Crumpet
Dare
Farrell
GUEST
Genting

Here is the actual result: (the result is get from your answer)

surname
--
Bader
Baker
Boothe
Butters
Coplin
Crumpet
Dare
Farrell
Genting
GUEST
AlisdairO commented 6 years ago

Ah, thanks a lot for the catch. This was the result of an operational screwup when updating the postgres database version. Fixed now.