Re: current_schemas() - Mailing list pgsql-docs

From Alvaro Herrera
Subject Re: current_schemas()
Date
Msg-id 20050730032115.GA21895@alvh.no-ip.org
Whole thread Raw
In response to Re: current_schemas()  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-docs
On Fri, Jul 29, 2005 at 10:30:13PM -0400, Bruce Momjian wrote:
>
> Why not just use pg_catalog.current_schemas()?

The function is current_schemas(bool), that's why this example doesn't
work:

> > teste=# SELECT current_schemas();
> > ERROR:  function current_schemas() does not exist
> > HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: current_schemas()
Next
From: David Fetter
Date:
Subject: Re: [HACKERS] PL/Perl list value return causes segfault