On Sat, 2002-09-07 at 14:39, Alvaro Herrera wrote:
> Hello,
>
> In http://developer.postgresql.org/docs/postgres/runtime-config.html,
> the SEARCH_PATH variable description mentions the use of
> current_schemas(), but this function doesn't exist (or it didn't exist
> last time I updated:
> #define CATALOG_VERSION_NO 200209021
> )
>
> What exists is current_schema(), but it doesn't expand to the full
> search path; apparently, only the first item that exists:
>
> testing=# set search_path to '$user', 'public', 'alvh1', 'alvh2';
> SET
> testing=# select current_schema();
> current_schema
> ----------------
> public
> (1 row)
Heres what I get. Note current_schemas() shows the full search path,
where current_schema() shows only the first.
a=# set search_path to k,l;
SET
a=# select current_schemas(true);current_schemas
------------------{pg_catalog,k,l}
(1 row)
