On Sun, 27 Sep 2020 at 23:39, Abhijit Menon-Sen <a...@toroid.org> wrote:
> postgres=# SET search_path += octopus; > SET > postgres=# SET search_path += "giant squid", kraken, narwhal; -- [1] > SET > postgres=# SET search_path -= public, narwhal; > SET > postgres=# SHOW search_path; > What happens if the new value for += is already in the list? What about -= on a value that occurs in the list multiple times?
