On Sun, 27 Sep 2020 at 23:39, Abhijit Menon-Sen <ams(at)toroid(dot)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?