X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CC84852988 for ; Tue, 5 Jul 2005 11:06:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04057-04 for ; Tue, 5 Jul 2005 14:06:11 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 8BFDA528C7 for ; Tue, 5 Jul 2005 11:06:10 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA01322B68; Tue, 5 Jul 2005 10:06:07 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Tue, 05 Jul 2005 14:06:07 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE300BA5E33; Tue, 5 Jul 2005 10:06:07 -0400 Received: from alvh.no-ip.org (216.155.79.182) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF600025CBF8; Tue, 5 Jul 2005 10:06:14 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id F12A7C2DC70; Tue, 5 Jul 2005 10:06:38 -0400 (CLT) Date: Tue, 5 Jul 2005 10:06:38 -0400 From: Alvaro Herrera To: Halley Pacheco de Oliveira Cc: pgsql-docs@postgresql.org Subject: Re: current_schemas() Message-ID: <20050705140638.GE4511@alvh.no-ip.org> References: <20050705111440.62083.qmail@web52704.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050705111440.62083.qmail@web52704.mail.yahoo.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.418 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200507/5 X-Sequence-Number: 3131 On Tue, Jul 05, 2005 at 08:14:40AM -0300, Halley Pacheco de Oliveira wrote: > 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. alvherre=# select current_schemas(true); current_schemas --------------------- {pg_catalog,public} (1 fila) alvherre=# select current_schemas(false); current_schemas ----------------- {public} (1 fila) Function parameters are essential when determining if a function exists or not. alvherre=# \df current_schema* Listado de funciones Schema | Nombre | Tipo de dato de salida | Tipos de datos de argumentos ------------+-----------------+------------------------+------------------------------ pg_catalog | current_schema | name | pg_catalog | current_schemas | name[] | boolean (2 filas) -- Alvaro Herrera () FOO MANE PADME HUM