Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] SET search_path += octopus - Mailing list pgsql-hackers

From Isaac Morland
Subject Re: [PATCH] SET search_path += octopus
Date
Msg-id CAMsGm5cVEwMWjBoe+zcBcAhtyMYhJkebtTrBfFW2_E6sVyPijg@mail.gmail.com
Whole thread Raw
In response to [PATCH] SET search_path += octopus  (Abhijit Menon-Sen <ams@toroid.org>)
List pgsql-hackers
Tree view
On Sun, 27 Sep 2020 at 23:39, Abhijit Menon-Sen <ams@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?

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] SET search_path += octopus
Next
From: Andres Freund
Date:
Subject: Re: [PATCH] SET search_path += octopus